Please Provide Select Query i am confused wih Joins

Hello All,

Please help with SQL to retrive data from the three table

tblRec
tblRecConsultant
tblRecRequirement

I want to include the Date field from tblRec and Name field from tblRecConsultant into the retrived data from tblRecRequirement ..

Finally i want all the columns from tblRecRequirement and Date field from tblRec and Name field from tblRecConsultant

In tblRec--ConsultantId is primary key
In tblRecRequirement --- Id is primary Key
In tblrecConsultant -- Id is primary Key

Please help

Replies will be appriciated..

Thank

Ajay

Thanks for posting. I would suggest you post this over at our sister forums, www.forums.devshed.com

We have a lot of SQL experts there that I am sure would be more than happy to assist you. You will need to create a new username, but will likely get a faster response.