Need help with JOIN

• Sab-380303

  Grasshopper

  Points: 18

  More actions

  November 4, 2006 at 2:47 pm

  #174834

  Hi all ,

  I kwow this is silly but I am a newbee would lke help with JOINS.

  I have two tables, Table A and Table B

  I need a query that will get the records of TABLE A that re not present in table B

  If I use the NOT the execution time is too long , pelase help.

  Select [IDNo], [Refno] TABLEA where (cty='NY') and ([ID no] not in (select [ID no] from TABLEB)

  group by [IDNo], [Refno]

  The query take a long time to complete (over 2 minutes) Can some one help pelase.

  Thanks

  Sab

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  November 4, 2006 at 5:22 pm

  #669969

  Try This

  Select idNo, RefNo

  From TableA

  Left Join TableB on TableA.IDNo = TableB.IDno

  where TableA.cty='NY'

    and TableB.IDNo is NULL

• Sab-380303

  Grasshopper

  Points: 18

  More actions

  November 4, 2006 at 6:40 pm

  #669970

  Ray, Thank you So much, it works

  Sab