Thank you, Norman.
John
On Mar 21, 2006, at 6:33 PM, Norman Palardy wrote:
Temp tables work well combined with the "insert into select" syntax
Basically select all the items from one table then all the items
from the second table that aren't already in the table
That will give you distinct items
If you just want all then just do the insert into select from each
source table
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
