Hey All,
Ive got 2 tables im trying get some results from
Table1 Table2
Fields A B A B
1 2 1 2
3 4 3 4
5 6
being a ms sql server man to get the items not matching between table 1 and 2, that are on table1 i would do the following
Select * from Table1,Table2 where Table1.A*=Table2.B and Table1.B*=Table2.B and (Table2.A is NULL)
the is null statement shoule give me all items in Table1 where there is no match with Table2, this doesnt work in SYBASE, How would i do this, HELP!!!!!
Cheers
Ive got 2 tables im trying get some results from
Table1 Table2
Fields A B A B
1 2 1 2
3 4 3 4
5 6
being a ms sql server man to get the items not matching between table 1 and 2, that are on table1 i would do the following
Select * from Table1,Table2 where Table1.A*=Table2.B and Table1.B*=Table2.B and (Table2.A is NULL)
the is null statement shoule give me all items in Table1 where there is no match with Table2, this doesnt work in SYBASE, How would i do this, HELP!!!!!
Cheers