Using Joins...

[AV1611]

If I had two tables:

Table A has some records that B doesn't

Table B has some records that A doesn't

I can do JOIN on FIELD1

I want ALL records...

Can't do left, can't do right... for obvious reasons...

[obsidian]

you can do a simple query and join the records in the WHERE clause:
[code]
SELECT * FROM table1 a, table2 b WHERE a.field1 = b.field1;
[/code]

[AV1611]

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) [snapback]354504[/snapback][/div][div class=\'quotemain\'][!--quotec--]
you can do a simple query and join the records in the WHERE clause:
[code]
SELECT * FROM table1 a, table2 b WHERE a.field1 = b.field1;
[/code]
[/quote]

[obsidian]

[!--quoteo(post=354586:date=Mar 13 2006, 12:53 PM:name=AV1611)--][div class=\'quotetop\']QUOTE(AV1611 @ Mar 13 2006, 12:53 PM) [snapback]354586[/snapback][/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?

[AV1611]

Let me try outer joins... I've never used it... but this is a common problem for me..

THANKS!