HAve a table called Master, with a value called UniqueID.
Have a second table called Actions, where the field called ID is the same as the Master table's UniqueID. (after a form processes, the UniqueID from Master is inserted into the Action table, along with an int called EventID
I want to include every record from Master, unless the UniqueID field matches the one in Action called ID AND the EventID field is the same as a variable passed by a form. (it's in CF, I can handle the variable part, just not sure where to put it.)
I have this so far:
FROM Master a LEFT OUTER JOIN Actions b ON a.UniqueID = b.DealerID
But I don't know how to add on the rest.