In Oracle, the syntax for a theta-style join (the one you're describing)
is:
SELECT ...
FROM ...
WHERE item1 (+) = item2
However, MySQL doesn't support this syntax. The only way to do left
(outer) joins in mysql is the way you described:
SELECT ...
FROM ...
LEFT JOIN ... ON ... = ...
-----Original Message-----
From: alvin townsend [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 24, 2001 2:02 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql and oracle outer join syntax
hello all.
i have a question - but first some background...
the standard LEFT JOIN syntax is something like this:
SELECT t1.a, t1.b, t1.c, t2.d, t2.e
FROM table1 t1 LEFT JOIN table2 t2 ON t1.x = t2.x
WHERE t1.a = 'some condition or another';
i much prefer to do LEFT JOINs like this however:
SELECT t1.a, t1.b, t1.c, t2.d, t2.e
FROM table1 t1, table2 t2
WHERE t1.x = t2.x
AND t1.a = 'some condition or another';
however, now i've got to convert this to an OUTER JOIN. i know that with
oracle, you can add a plus somewhere like this (although i'm unclear
what the precise syntax is):
SELECT t1.a, t1.b, t1.c, t2.d, t2.e
FROM table1 t1, table2 t2
WHERE t1.x = t2.x+ [note the plus here]
AND t1.a = 'some condition or another';
and now the question....
does anyone know if there's a way with mysql to use the oracle-esqe + to
do an OUTER JOIN so i don't have to go back and rewrite all of my sql
statements?
thanks a lot!
alvin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
