I'm a novice when it comes to MySQL so I'm not too sure about how to go about this. I have two tables, and both tables have two fields I need to deal with.
Table investors has fields Dealer and Rep. Table advisors has fields dealer and rep.
investors.Dealer = advisors.dealer AND investors.Rep = advisors.rep
What I need is to find records in Table One with A and B, but those values for A and B are not in Tables Two's a and b. Make sense?
I found some sql statements that should find what I need, but using only one field.
select * from A left join B on A.x = B.y and B.y is null
How can I use this with both my Dealer/dealer AND Rep/rep fields?