help with query

[NickMalloy]

I have three tables and want to combine them for a query

main
----
order_by
deptid
title
name
building

department
----------
deptid
deptname

building
--------
buildingid
buildingname

I want to grab everything in the main table, but I want to replace the deptid with the name that corespondes in deptname and do the same for building. Can someone help me with this?

 

[DotNetGnat]

try this:

SELECT A.order_by, B.deptname,A.title, A.name, C.buildingname FROM main A, department B,
building C WHERE
A.deptid=B.deptid AND A.building=C.buildingid

-DNG