RE: [PHP] php - mysql problem
| From: | Jay Blanchard | Date: | Fri, 14 Apr 2006 17:51:34 +0000 |
| Subject: | RE: [PHP] php - mysql problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-234009@lists.php.net to get a copy of this message | ||
[snip]
table1
id
name
value
table2
id
x
y
i want to
id name value x y
but there is no id from table 2 that is in table2.id and i want the
resource to bu something like this:
id(from table 1) name value (empty) (empty)
> SELECT table2.*
> FROM table1 LEFT OUTER JOIN table2
> ON(table1.id = table2.id)
> WHERE table1.id IS NULL
[/snip]
> SELECT table1., *table2.*
> FROM table1 LEFT OUTER JOIN table2
> ON(table1.id = table2.id)