Originally Posted by
ridders52
Just select the field(s) you want in the query designer.
I'm afraid OP is not by JOIN yet!
When the results where only rows with YourSecondTableText determined are returned are wanted:
Code:
SELECT t1.YourFirstTablePK, t2.YourSecondTableText ROM tblYourFirstTable t1 INNER JOIN tblYourSecondTable t2 ON t2.YourSecondTablePK =t1.YourFirstTableFK
When all records from YourFirstTable must be returned, with Null as YourSecondTableText when no match exists, or when FK in YourFirstTable is empty:
Code:
SELECT t1.YourFirstTablePK, t2.YourSecondTableText ROM tblYourFirstTable t1 LEFT JOIN tblYourSecondTable t2 ON t2.YourSecondTablePK =t1.YourFirstTableFK