Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uncommon records from 2 table
Message
From
03/11/2002 23:51:09
 
 
To
03/11/2002 13:16:06
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00718301
Message ID:
00718366
Views:
28
Thanks for your repply
i like to explain my problems. I Have two Table Like

Table A

Name Address serial_no

Kasham. 259/c khilgaon. 1
shanta. 116/a Kuril. 2
moni. 541 Bashabo. 3
mimi. 112 bonani. 4


Table B

Name serial_no

shanta. 2
moni. 3


Table A is Master Table, has all records and Table B was selected from Table A base on a catagory.
Now i want to findout uncommon(differrence) records between Table A and Table B base on serial_no.
serial_no is a UNIQUE between two table.my query result should be look like this


query result

name address Phone_no

Kasham. 259/c khilgaon. 7212967
mimi. 112 bonani. 8823695




Please help me to get my result
Thanks.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform