Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
adonweb
Starting Member
4 Posts |
 Posted - 2010-06-19 : 09:26:50
|
| i have 3 tables namely:departments, divisions, secretarydepartments---------------------------id,departmentname, divisionid,secretaryidDivisions---------------------------id,divisionnameSecretary--------------------------id,namedepartmentidi need to show the result in the following format.departmentname divisionname secretaryname=============== =============== =================dept1 div1 sec1dept2 div2 dept3 div1 sec2 dept4 div2 sec2dept5 div1 sec1how can i write a query to produce the above result. I m using ms access |
|
|
SD_Monkey
Starting Member
38 Posts |
Posted - 2010-06-19 : 23:11:30
|
| [code]Select b.departmentname,a.divisionname,c.namefrom Divisions a inner join (departments b inner join Secretary c on b.secretaryid on c.id) on a.id=b.divisionid[/code]hope this can help...A maze make you much more better |
 |
|
|
|
|
|
join multiple tables