Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Vilhelm-Ion Praisach
  Where is Vilhelm-Ion Praisach?
 Resita
 Romania
 Vilhelm-Ion Praisach
 To: sandeep singh
  Where is sandeep singh?
 ludhiana
 India
 sandeep singh
 Tags
Subject: RE: Querry
Thread ID: 395891 Message ID: 395893 # Views: 64 # Ratings: 2
Version: Visual FoxPro 9 Category: VFP and .NET
Date: Tuesday, January 21, 2014 6:26:49 AM         
   


> Hi Expert
> How Can find itcode not enter sale.dbf
> item.dbf
> itcode | itname
> 00001 | item1
> 00002 | item2
> 00003 | item3
> 00004 | item4
>
> sale.dbf
>
> itcode | itname
> 00002 | item2
> 00004 | item4
>
> How can find
>
>
> Sandeep Singh (Ludhiana)

SELECT * FROM item WHERE itcode NOT in (SELECT itcode FROM sale)

My respects

ENTIRE THREAD

Querry Posted by sandeep singh @ 1/21/2014 6:19:00 AM
RE: Querry Posted by Vilhelm-Ion Praisach @ 1/21/2014 6:26:49 AM