I have three tables that are linked together and I'm having difficulty
designing a SQL query to get the correct information. The setup is this:
Both the tblRollout.PCStatus and tblRollout.KitStatus fields are "lookup"
fields that reference the ID_tblShipStatus from tblShipStatus.
I can create a SQL Statement "SELECT StoreNo, StatusText FROM tblRollout
INNER JOIN tblShipStatus ON tblRollout.PCStatus =
tblShipStatus.ID_tblShipStatus" which will return the Store Number and the
"text" PC Status. I'd like to be able to create a SQL Statement that would
return the Store Number, the "text" PC Status, the "text" Kit Status, and
the "text" Install Status from the third table.
I'm relatively new at SQL and appreciate any help you can give me!