That won't do it because if A exists and B doesn't you won't get A and vice versa...
[!--quoteo(post=354504:date=Mar 13 2006, 09:36 AM:name=obsidian)--][div class=\'quotetop\']QUOTE(obsidian @ Mar 13 2006, 09:36 AM) [/div][div class=\'quotemain\'][!--quotec--]
you can do a simple query and join the records in the WHERE clause:

[!--quoteo(post=354586:date=Mar 13 2006, 12:53 PM:name=AV1611)--][div class=\'quotetop\']QUOTE(AV1611 @ Mar 13 2006, 12:53 PM) [/div][div class=\'quotemain\'][!--quotec--]That won't do it because if A exists and B doesn't you won't get A and vice versa...[/quote]

ah, i see what you're saying. did you try OUTER JOIN?

You can't win, you can't lose, you can't break even... you can't even get out of the game.