[prev in list] [next in list] [prev in thread] [next in thread]
List: php-db
Subject: RE: [PHP-DB] Multiple table select, but still returning row if no record exists in second table?
From: "John W. Holmes" <holmes072000 () charter ! net>
Date: 2002-10-31 3:13:14
[Download RAW message or body]
LEFT JOIN
> -----Original Message-----
> From: Leif K-Brooks [mailto:eurleif@buyer-brokerage.com]
> Sent: Wednesday, October 30, 2002 9:49 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] Multiple table select, but still returning row if no
> record exists in second table?
>
> I'm using mysql. Is there any way to do a multiple-table select, but
> still return the results from table 1 if there are no matching rows in
> table 2? Something like "select table1.something,table2.something as
> something2 from table1,table2 where table1.table2id = table2.id" will
> only return the data from table1 if a row with the id in
table1.table2id
> exists in table2.
>
> --
> The above message is encrypted with double rot13 encoding. Any
> unauthorized attempt to decrypt it will be prosecuted to the full
extent
> of the law.
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic