How to join?

• mpk_1980

  Grasshopper

  Points: 18

  More actions

  October 6, 2010 at 12:23 am

  #224724

  I am using sql server 2000. Below is the scenario:

  I have 3 tables:

  select * from A1;

  gives:

  agentid, actid

  1, 100

  select * from B1;

  gives:

  actid, restid

  100, 200

  100, 202

  select * from C1;

  gives:

  restid, plancode

  200, AB

  201, AC

  202, AD

  With the given information, we see that agentid: 1 have account id 100 and restricted with

  200 and 202. We need a query, such that it finds the restricted id (restid) which is not

  included for this agent and its plan code.

  i.e., i need a query such that it displays

  agentid, restid, plancode

  1, 201, AC

  With this above output, we understand that agent is not restricted to use the plan code AC.

  Can u please help!. It is sql server 2000.

  Thanks

  Premkumar

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  October 6, 2010 at 2:15 am

  #1232297

  Please don't crosspost. It just wastes people's time and fragments replies.

  No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic998994-8-1.aspx

  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