I have a sql query that works well. I need to add an additional field form tblIR called review
(table) BUT it does not always have a record for the field used as the key.
When I add "and f..gateid = a.gateId to current sql query, I lose rows, since it is only bringing back matching rows.
Is there a way to code a join for table a (a.gateid) and table f (f.gateid) without having to recode the sql query so if there is no record, the field for "review" is blank. If there is a hit it says "yes:.
(or do I have to code into joins for the whole sql query?)