Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: abheja
  • Content: Threads
  • Order by date
  1. abheja

    Quering multiple tables

    I have two TABLES [A] and [B] with these attributes. A -ssn -id1 B -ssn id2 I want to find all SSN from A whose id1 does not exist in id2. I can find all ssn in A not in SSN B. Select * from A where ssn not in(select ssn from A, B where a.ssn=b.ssn) but how do I get all the SSN and the ID1...

Part and Inventory Search

Back
Top