hi plz help me to solve my problem. i have two tables A and B A B ----------------------------------------------- SRNO STATUS SRNO STATUS ------------------------------------------------ 101 A 101 X 102 NULL 102 Y 103 NULL 103 Z 104 B 104 W ------------------------------------------------ I M TRYING FOR A QUERY FOR THE FOLLOWING OUTPUT : -------------------- SRNO STATUS ------------------- 101 A 102 Y 103 Z 104 B ----------------- THANKS :-):rose: -- modified at 10:01 Monday 13th February, 2006

could you explore more about your problem. try... insert into A values ( select from B) .

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

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.

thanks, through it i solved my problem. thanks again.

thanks, than what can i do ? :confused:

can i use a subquery field to my main query. i.e select x.field1,y.field2 from tbl1 as x where x.field3 not in (select y.field3 from tbl2 as y) :confused:

i have an applet, and want to pass parameter through javascript. could some one help me on this? thanks:rose:

update command for interchanging to field values ex. f_name L_name -------------------------- a b c d by mistake f_name went to l_name and vise varsa:)