It has outer joins:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOI
N
HTH
Sam Masiello
Software Quality Assurance Engineer
Synacor
(716) 853-1362 x289
[EMAIL PROTECTED]
-----Original Message-----
From: Martín Marqués [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 4:35 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP] fix my query please
On Mar 28 Ago 2001 17:29, Jeremy Morano wrote:
> an somebody please fix up my query.
>
>
>
>
> $connection = @mysql_connect("l", "c", "c") or die("Couldn't connect.");
>
> $db = @mysql_select_db($db_name, $connection) or die("Couldn't select
> database.");
>
>
>
> $sql = "SELECT distinct users.uid , users.username
> FROM users LEFT OUTER JOIN picks using(id)
Am I an ignorant, or MySQL doesn't have OUTER JOINs!!!!
> Where users.uid <> picks.user_id
> ";
[snip]
Saludos... :-)
--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | [EMAIL PROTECTED]
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
--
PHP General 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 General 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]
