how to retrive a data.

• immaduddinahmed

  Ten Centuries

  Points: 1375

  More actions

  December 8, 2014 at 5:41 am

  #151391

  hi,

  i have two tables

  Table A

  Table B

  i want a Query that retrive a Data.

  That Does not have a Data in Table B but Have a Data in Table A.

  PLease Help me out.

  Thanks for the help.

  immad

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  December 8, 2014 at 5:51 am

  #1763246

  Errrr.....

  NOT EXISTS or NOT IN, if I've understood what you're asking.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  December 8, 2014 at 6:06 am

  #1763251

  GilaMonster (12/8/2014)

  ---

  Errrr.....

  NOT EXISTS or NOT IN, if I've understood what you're asking.

  or EXCEPT 😀

  Far away is close at hand in the images of elsewhere.
  Anon.