Joining multiple Tables

[CLIRAM]

Given 3 tables A, B, and C containing the following contents

A.CID
A.PID
A.Data

B.CID
B.Name

C.CID
C.PID
C.Name

What SQL statement would give a result set containing all data in Table A and the associated Name fields from Tables B and C. PID in Table A may be blank. PID in Table C is never blank.

If this information is not clear enough let me know and I will try to expand on it.

Any help would be appreciated.

 

[PHV]

What are the relationships ?
The A.CID refers to B or to C (in conjunction with PID) ?
A starting point:
SELECT A.CID,A.PID,A.Data,B.CID,B.Name,C.CID,C.PID,C.Name
FROM (A LEFT JOIN B ON A.CID=B.CID)
LEFT JOIN C ON A.CID=C.CID AND A.PID=C.PID

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[CLIRAM]

Thanks,

This appears to do what we need.