In the following qry, I need to show all records on the left side. Many projects do not have an associated record in the tblLetterOfCredit based on ProjectID. I need help to show ALL records on tblProjects even if there is not a match on tblLetterOfCredit.
How can I do this? Please see attachment