Display data when in multiple tables...

• murrayb3024

  SSC Rookie

  Points: 48

  More actions

  September 19, 2007 at 1:41 pm

  #181101

  I am not really sure how to do this or if this is even doable. I have 4 tables (A,B,C,D) with a piece of data that may be in one or up to all four. I want to write a query that will show what table that data can not be found in. So data1 is not in C, data2 is not in A or D. Any ideas or examples?

• noeld

  SSC Guru

  Points: 96590

  More actions

  September 19, 2007 at 4:06 pm

  #734738

  Posting sample DDL of your tables can help us help you with the queries

  
  * Noel

• Prashant Pandey

  SSChasing Mays

  Points: 657

  More actions

  September 21, 2007 at 2:18 am

  #735143

  Hi murrayb3024 ,

  Please post the scenario by specifying table name and column then wht is desired output u want???

  liek below,

  Table test1

  Id Name

  1 Hello

  2 Hi

  Table Test2

  Id Class

  1 12

  2 10

  Desired Output

  Id Name Class

  Liek this post your problem it will help us to understand and answer your question more clearly.

  Thanks,
  Prashant