Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
2 tables, Same records, How seek with SELECT?
Message
 
To
12/11/1997 09:16:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00059325
Message ID:
00059888
Views:
33
>>And query:
>>Select * from Table1 ;
>>where Table1.Key1+Table1.Key2+Table1.Key3 NOT IN ;
>>(Select Table2.Key1+Table2.Key2+Table2.Key3 From Table2)
>>is notsatisfactory for me.
>>Do you understand me?
>
>Not exactly. It doesn't matter how many fields constitute primary key. And it doesn't matter how identical tables are. The only thing you should care is primary key which allow you to bring missing (or all minus missing, etc) records form one of the table. Maybe, you could give an example what records you really expect to retrieve.

Main thing is that there isn't one field as primary key, there is three!
Giedrius
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform