Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Uncommon records from 2 table
Message
De
03/11/2002 23:51:09
 
 
À
03/11/2002 13:16:06
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00718301
Message ID:
00718366
Vues:
29
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform