[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) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
