RE: [PHP] getting from one table listing from another
| From: | Jay Blanchard | Date: | Sat, 18 Aug 2007 23:12:28 +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-261007@lists.php.net to get a copy of this message | ||
[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.