SQL : SubQuery

[dev_rfid]

hi i have three tables named A,B,C having common field srno. A b c ---- ------- ---- srno srno srno ---- ------- ------ 101 101 102 102 105 103 104 105 i wrote a query like : (A.srno) - (B.srno) - (C.srno) and my ans is :103 and 104 but in a critical situation 102 is again inserted in A. not assign to B or C. but didn't display in my query. plz. help me.

[Colin Angus Mackay]

I don't understand what you are trying to achieve. Could you explain? Also, what is your current SELECT statement? ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

[dev_rfid]

sorry, i couldn't explain properly. i am trying to explain by example : i have two tables A and B having common field SRNO. in table A i have values 101,101,101,102,102,103. in table B i have values 101,102. i want to write a query from A nad B, which provide me the output : 101,101,102,103. means : 101,101,101 in A - 101 in B = 101,101 in Output 102,102 in A - 102 in B = 102 in output 103 in A - null = 103 in output actually i wrote like : select srno from A where srno not in (select srno from B) but it eliminate all the instances of srno. the output is only :103. but i want as defined above. could i tried well to make you understand my problem? thanks:rose: -- modified at 5:21 Saturday 11th February, 2006