Novice Select SQL Statement

[dungstar]

This should be a simple SQL statement; I've done it before but just can't figure it out now.

I have a LabSample table. The lab sample has couple fields that are foreign keys TechID (from Technician table) and ProjectID (from Project table).

Not all records in the LabSample table contain a TechID or ProjectID.
Under the Technician table, the attributes are TechID (PKey), TechName.
Under the Project table, the attributes are ProjID (PKey) and PI (investigator).

I am trying to create a query, that shows all LabSample attributes and if a TechID exist, also show TechName, and if ProjID exist, also show the PI.

Thanks for your help!