Help need in SELECT statement

• rs

  SSCrazy

  Points: 2819

  More actions

  March 5, 2004 at 2:24 pm

  #107680

  I have two tables called TableA and TableB

  TableA

  Col1 ID

  Col2 CDate

  Cpl2 name

  TableB

  Col1 ID

  Col2 CDate

  Cpl2 name

  for particular time period i need to select rows from tableA not exist in TableB

  Like

  SELECT * FROM TableA WHERE (CDate BETWEEN date1 and date2) AND ID NOT IN

  (SELECT ID FROM TableB WHERE (CDate BETWEEN date1 and date2))

  Is there any best way to do this, please help me if you have any solutions.

  Thanks

  srgangu

• noeld

  SSC Guru

  Points: 96590

  More actions

  March 5, 2004 at 2:34 pm

  #497657

  select A.*

  from TableA A LEFT JOIN TableB B

  ON A.ID = B.ID

  Where B.ID IS NULL And (A.CDate BETWEEN date1 and date2)

  
  * Noel

• rs

  SSCrazy

  Points: 2819

  More actions

  March 5, 2004 at 3:28 pm

  #497666

  Thanks, It worked.