Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Amethystium
Aged Yak Warrior
701 Posts |
 Posted - 2003-10-14 : 12:31:09
|
| Say I have a table A with 5 columns and a table B with 5 columns also.How do I do something like Table A - Table B ?Like I want to know the differenc between the two table. And yes the two tables are derived tables so they can be made to be identical.Any suggestions?__________________Make love not war! |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-10-14 : 16:17:43
|
| Am-um,what do you mean? What can we use in Access instead of FULL OUTER JOIN?If so, thenSELECT a.* FROM a LEFT JOIN b ON ... ... WHERE ... IS NULL AND ... IS NULL ...UNION ALLSELECT b.* FROM a RIGHT JOIN b ON ... ... WHERE ... IS NULL AND ... IS NULL ...If you mean table structures then I think MSysObjects table can help. |
 |
|
|
|
|
|
Difference between two tables