-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
El Vie 23 Ene 2004 17:08, Chris Boget escribió:
> Can you UNION 2 queries and use the result to JOIN with another table?
>
> (SELECT tableA.name, tableC.company FROM tableA)
> UNION
> (SELECT tableB.name FROM tableB)
> LEFT JOIN tableC ON tableA.name = tableC.name;
>
> This doesn't work. But I don't know if it isn't working because I have the
> wrong syntax or if it's simply not possible with SQL/MySQL.
>
> thnx,
> Chris
for example:
select X.name, tableC.company
from
(
(SELECT tableA.name FROM tableA)
UNION
(SELECT tableB.name FROM tableB)
) X
LEFT JOIN tableC ON X.name = tableC.name;
or
( SELECT tableA.name, tableC.company
FROM tableA
LEFT JOIN tableC ON tableA.name = tableC.name;)
UNION
( SELECT tableB.name, 'x' as company FROM tableB)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQFAGHJTWq/JyzWau9ARAlSoAKDerQP/rhUKi5PPSP5rVXpc8S5lNQCeJ3aH
cowaLdKERCYs0CClEvf2lMM=
=hC9h
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
