Re: fix my query please
| From: | Martín Marqués | Date: | Tue, 28 Aug 2001 20:35:04 +0000 |
| Subject: | Re: fix my query please | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-64876@lists.php.net to get a copy of this message | ||
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 | mmarques@unl.edu.ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------