On Mar 21, 2006, at 2:22 PM, John Balestrieri wrote:
Hi,
I need to merge 2 database tables based on a matching field. I don't
want any rows in either table to be omitted. Normally, I suppose I'd
use a full outer join?
SQLite does not support full outer joins -- so is there any way to
simulate that by using a temp table or complex/compound SQL query?
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>
