SQL Query question

• kiran-197412

  Newbie

  Points: 1

  More actions

  December 22, 2004 at 1:35 pm

  #162960

  a1 and a2 have same structure, but a1 has more records than a2. so, in order to find out how many records are missing in a2 the below query works. but is there a way to write the below query using joins.

  Select * from a1 where stoptime not in (select stoptime from a2)

  please

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  December 22, 2004 at 2:07 pm

  #534831

  select a1.* from a1 left join a2 on a1.stoptime = a2.stoptime where a2.stoptime is null

  This would also work for tables without the same structure, as long as the tables can be joined on with a foreign key field(s).

   

  Kathi

   

   

   

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor