-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 =
"Chris Boget" <[EMAIL PROTECTED]> wrote:
> 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 kn
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
