I have 3 tables and want data from the first 2, but only want data from the third on the rare times that there is a match in tables 2 & 3. If the conditions are not met in table 3, I don't get the results i still want from table 1 & table 2.
Is there any way to do this in one query, without having dummy records in table 3? I think of this problem as "false negatives". (I guess this actually breaks the fundamental concept of a Query) Thanks, Simon