Maurice van Peursem wrote:
Hello,
I like to have a full outer join. if you have the following tables:
t1:
id | val
1 | A
2 | B
t2:
id | val
1 | B
2 | C
SELECT t1.id, t2.id, t1.val FROM t1 FULL OUTER JOIN t2 ON t1.val=t2.val
ORDER BY t1.id,t2.id
I want to get the following result
Hello,
I like to have a full outer join. if you have the following tables:
t1:
id | val
1 | A
2 | B
t2:
id | val
1 | B
2 | C
SELECT t1.id, t2.id, t1.val FROM t1 FULL OUTER JOIN t2 ON t1.val=t2.val
ORDER BY t1.id,t2.id
I want to get the following result (and in this order):
t1.id
[EMAIL PROTECTED] wrote on 04/04/2005 01:14:23 PM:
> 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 do
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
According to the MySQL documentation, it doesn't currently support full
outer joins and won't do in the immediate future. Does anyone have any
suggestions for a workaround?
I need to join three tables, only one of which has a common identifier with
the others, and produce a result which shows
