This week's book giveaways are in the iOS and Features new in Java 8 forums. We're giving away four copies each of Barcodes with iOS: Bringing together the digital and physical worlds and Core Java for the Impatient and have the authors on-line! See this thread and this one for details.
Hi ! I have 2 tables with the following structure: Table 1: A | B | C --------- rec.1 a1| b1| c1 rec.2 a1| b2| c1 and Table 2: B | C | D ----------- b1| c1| d1 b2| c2| d2 Could someone help me with a query which finds all records from Table 2 with the pair (b,c) which are NOT present in Table 1. (In above eg. it should return (b2, c2, d2) since the pair (b1, c1) is present in Table 1) I'm sure its a simple query .. but can't seem to think of anything. Thanks in advance, Anoop
[This message has been edited by Nair Anoop (edited September 19, 2001).]
hi to make it a bit more simpler for you try this query............... select table2.b, table2.c, table2.d from table2, table1 where not (table2.b=table1.b or table2.c=table.c); i hope this would work as per your requirement all the best namita