RE: [PHP] getting from one table listing from another
- From: jblanchard@xxxxxxxxxx ("Jay Blanchard")
- Date: Sun, 19 Aug 2007 12:39:04 -0500
[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.
.
- Prev by Date: Re: [PHP] getting from one table listing from another
- Next by Date: Re: [PHP] getting from one table listing from another
- Previous by thread: Delete row in a lookup table
- Next by thread: RE: [PHP] getting from one table listing from another
- Index(es):
Relevant Pages
|
