how to querry for list of branches for each company

[developerit]

hi, iam using sql server 2000 , the table fields are brabchid nvarchar(50), branchname nvarchar(50), companyid nvarchar(50), startdate datetime, enddate datetime 1)how to querry for list of branches for each company please give me example which helps me.

[Mycroft Holmes]

Get a book and work through some examples. Fire up query analyser and try something yourself

SELECT
C.ComapnyName,
B.BranchName
FROM Branch B
INNER JOIN Company C ON C.CompanyID = B.ComapnID

Never underestimate the power of human stupidity RAH