SQL server query help

I have 3 tables with following relationship.

TABLE_A:
 A_ID
 Name

TABLE_B:
 B_Id
 B_DESC
 A_ID

TABLE_C:
  C_ID
  C_DESC
  B_ID

I am trying to write the following query to get the results. For each A_ID there are many rows in TABLE_B and TABLE_C has many rows for 开发者_如何学Ceach B_ID. Could you please let me know how to write the query to the results? Thanks for your help.

SELECT B_ID, B_DESC, C_DESC FROM TABLE_B B JOIN TABLE_C C on B.B_Id = C.C_ID WHERE A_ID = 4 

The Format I am trying to get:

    B_ID   B_DESC
        C_DESC1
        C_DESC2
        .......
    B_ID    B_DESC
        C_DESC1
        C_DESC2
        C_DESC3 

Thanks for your help.

You're joining B_ID to C_ID; try the following:

SELECT 
 B_ID, 
 B_DESC, 
 C_DESC 
FROM 
 TABLE_B B 
 JOIN TABLE_C C 
  on B.B_ID = C.B_ID 
WHERE A_ID = 4 

This will get you started...

SELECT * FROM TABLE_A A INNER JOIN TABLE_B B ON (B.A_ID = A.A_ID) INNER JOIN TABLE_C C ON (C.B_ID = B.B_ID) WHERE A.A_ID = 4

select *
from TABLE_A ta
join TABLE_B tb on tb.A_ID = ta.A_ID
join TABLE_C tc on tc.B_ID = tb.B_ID
where ta.A_ID = 4