Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: onytoo
  Where is onytoo?
 Padang
 Indonesia
 onytoo
 To: mohammed qasem
  Where is mohammed qasem?
 amman
 Jordan
 mohammed qasem
 Tags
Subject: RE: subtract 2 fields
Thread ID: 289194 Message ID: 289197 # Views: 46 # Ratings: 2
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 29, 2010 9:28:58 AM         
   


> hi all,
>
> i try as below ...wrong result ane repated values
>
> SELECT  ( TAlias1.f4-TAlias2.f4) as newf4,( TAlias1.f6-TAlias2.f6) as newf6 FROM mytab  TAlias1,mytab1 TAlias2 into CURSOR mycur
> 

> thanks

SELECT (TAlias1.f4-TAlias2.f4) AS newf4, ;
  (TAlias1.f6-TAlias2.f6) AS newf6 ;
  FROM mytab TAlias1 ;
  LEFT JOIN mytab1 TAlias2 ON TAlias1.id=TAlias2.id_talias1 ;
  INTO CURSOR mycur


Regards,
Onytoo

ENTIRE THREAD

subtract 2 fields Posted by mohammed qasem @ 12/29/2010 8:47:07 AM
RE: subtract 2 fields Posted by Ony Too @ 12/29/2010 9:28:58 AM
RE: subtract 2 fields Posted by Anders Altberg @ 12/29/2010 7:48:22 PM
RE: subtract 2 fields Posted by mohammed qasem @ 12/30/2010 5:39:49 PM