"Jumping" 2 tables in a single SELECT statement

• W3bbo

  SSC Rookie

  Points: 25

  More actions

  September 16, 2005 at 5:05 pm

  #187598

  'lo

  Consider this:

  Table A

  - ID

  - Name

  Table B

  - ID

  - AID (FK for A.ID)

  - Name

  Table C

  - ID

  - BID (FK for B.ID)

  - Name

  I'm wanting to return rows from Table C. No problem:

  SELECT C.* FROM C WHERE C.ID = @ID

  I'm also wanting to return the B.Name for the FK B.ID; again, no problem:

  SELECT C.*, B.Name FROM C, B WHERE C.ID = @ID AND B.ID = C.BID

  I'm also wanting to return A.Name for the FK B.AID... problem:

  How the heck do I do that?

  I'm wanting the returned table to have these fields:

  C.ID | C.BID | C.Name | B.Name | B.AID | A.Name

  So... how?

• Merrill Aldrich

  SSCrazy

  Points: 2358

  More actions

  September 16, 2005 at 5:21 pm

  #590769

  Just a join, right?

  select c.id, c.bid, c.name, b.name, b.aid, a.name

  from c

  inner join b on c.bid=b.id

  inner join a on a.id=b.aid