Hello all, mysql 4.0.20
I'd like to know how one can do a "full outer join". I've read some workaround with a UNION, but i need the join only on a few columns, while UNION will make double tuple if one column is not the same. I also would like to avoid temporary table if possible, since the query is on many millions of rows, and i saw performances suffer when working on multiple temporary tables. If anyone has an idea, he would be great. Thanks you Vincent -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]