I'm sure there is a simple solution to this problem, I just can't get my head around it:<br><br>I have two tables, A and B.<br><br>Each entry in table A has any number of corresponding entries in table B.<br><br>I want to know which entries in A contain two (and only two) specific entries (say "a" and either "x","y", or "z"
in B<br><br>right now, I am getting singles (record contains one of a,x,y,z) and duplicates (A.entry_id shows up twice because there are 2 records in B.entry_type: ("a" and "x." )<br><br>Thanks in advance for your help<br>alc<br>
in B<br><br>right now, I am getting singles (record contains one of a,x,y,z) and duplicates (A.entry_id shows up twice because there are 2 records in B.entry_type: ("a" and "x." )<br><br>Thanks in advance for your help<br>alc<br> 