Find Records in a table that are not in other tables

• No Idea

  Say Hey Kid

  Points: 675

  More actions

  October 19, 2009 at 3:14 pm

  #212221

  I have 3 tables (CO, UI, PI) and for this example each table only has one variable (ID).

  I need to know:

  1. Which records in the CO table are in the UI table but NOT the PI table.

  2. Which records in the CO table are not in UI table or in the PI table.

  The ID field is an integer in each of the 3 tables.

  I did a search for this because I'm sure it's not too difficult, but I wasn't sure how to word the search criteria.

  Thanks!

• Piotr.Rodak

  SSCrazy Eights

  Points: 9376

  More actions

  October 19, 2009 at 4:33 pm

  #1067863

  Please have a look at IN (and NOT IN) predicate of WHERE clause in Books On Line.

  Regards

  Piotr

  ...and your only reply is slàinte mhath