RE: [PHP] getting from one table listing from another
| From: | Jay Blanchard | Date: | Sun, 19 Aug 2007 19:48:03 +0000 |
| Subject: | RE: [PHP] getting from one table listing from another | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-261023@lists.php.net to get a copy of this message | ||
[snip]
However, the LEFT and RIGHT will take me a while to figure out.
[/snip]
FROM table a LEFT OUTER JOIN table b
ON(a.column = b.column)
Just follow the order tedd, a is on the left and b is on the right
LEFT OUTER -> a -> b (what may be in a might not be in b)
a <- b <- RIGHT OUTER (what may be in b might not be in a)
FROM table a INNER JOIN table b
ON(a.column = b.column)
a -> INNER JOIN -> b (only where in a and b)