Query doesn't return expected results

[Jen]

Hi Jon,

What you need is an Outer join. It would look something
like this:

SELECT TBL_ISSUES.*, TBL_ACTION_ITEMS.*
FROM TBL_ISSUES LEFT OUTER JOIN TBL_ACTION_ITEMS ON
TBL_ISSUES.ISSUE_ID = TBL_ACTION_ITEMS.ISSUE_ID;

Regards,
Jen