subject:"\(Left\) Join and Union"

Re: (Left) Join and Union

2004-01-28 Thread Ariel Santana (HotPOP)

-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 =

Re: (Left) Join and Union

2004-01-26 Thread Victoria Reznichenko

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 know if it

(Left) Join and Union

2004-01-23 Thread Chris Boget

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