how to write the querry for user belongs to a company all related branches

[developerit]

iam usin sql server 2000, the table are as follows tbluser ======== username nvarchar(50) pk usertype nvarchar(50) companyid nvarchar(50) fk tblcompany ========== companyid nvarchar(50) pk company name nvarchar(50) tblbranch ======== branchid nvarchar(50) pk branchname nvarchar(50) companyid nvarchar(50) location nvarchar(50) how to write the querry for user belongs to a company all related branches please give the example which helps me.

[Mycroft Holmes]

Now you are pushing it, what have you tried? Use the inner join example and extend it to include the user table. Don't just ask for the code, put up something you have tried and we may point out whee you are going wrong. Asking for examples all the time is like asking us to write your code for you and is :mad: discouraged.

Never underestimate the power of human stupidity RAH

[developerit]

iam using this query but not getting the proper result. select companyname,branchname,location from users,company,branch on user.companyid=company.companyid innerjoin company.companyid=branch.branchid i want the user blongs to the company and all related branches can you suggest.