Inner Join And Union Help Needed

Ok, getting a little better at joins, but now need to take it two more steps.

Main table tblEquipments

Fields: ID, EquipmentType, Location, Status

Second Table tblEquipments_Group

Fields: equipmentID, categoryID, subCategoryID
(all are ints)

I joined these two together and got the info back I needed:

SELECT a.ID, a.Description, a.Status, a.Location,
from tblEquipments a
inner join tblEquipments_Group U on u.categoryID = a.EquipmentType
and u.subCategoryID = @type

Now, the a.status returns a number. What the status actually is is in tblStatus.

Fields: statusID (int) , Status (varchar).

So, the statusID matches a.Status.

I need to get the text from tblStatus in the field Status and replace the a.Status (which is a number still) with the text.


The other one, location, is the same situation.

I've been trying to do another join and am at an end on this.

Suggestions?

Thanks!!

Zath