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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement