[snip] At 6:12 PM -0500 8/18/07, Jay Blanchard wrote: >[snip] >I know this is kinda crazy but I need it :P >I have one table that lists name's >and I have another table that has the name's and points >I want to know how to list the name's of the first table by the points >of the second table >[/snip] > >Not crazy, pretty standard from a database point of view; > >SELECT a.name, b.points >FROM table a LEFT OUTER JOIN table b >ON(a.name = b.name) > >This only works if the name in table a matches a name in table b. Then why use a JOIN? It's my understanding that JOINs are used to included unmatched rows -- am I wrong? [/snip] Exactly. If there is a name in table a that has no points in table b you will see the name from a and a NULL from b. If you only want names that have points you can use the implicit join that you illustrate. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
