FW: [PHP] getting from one table listing from another

From: jblanchard@xxxxxxxxxx ("Jay Blanchard")
Date: Mon, 20 Aug 2007 06:26:27 -0500

[snip]
Question -- is it redundant to say:

FROM table a LEFT OUTER JOIN table b
ON(a.column = b.column)

when "table a" appears first? Wouldn't that be the same as:

FROM table a OUTER JOIN table b
ON(a.column = b.column)
[/snip]

An OUTER JOIN is essentially a FULL OUTER JOIN which will include
matches and non-matches from both tables. The order of tables is only
important when specifying LEFT or RIGHT outer join. Some RDBMS implement
this differently so for clarity you should always be very specific.
.

Prev by Date: Re: [PHP] Redirection with header (was Re: [PHP] Cookies and sent headers)
Next by Date: Pass $_GET to php cli.
Previous by thread: Re: [PHP] getting from one table listing from another
Next by thread: Render fonts
Index(es):
- Date
- Thread

Relevant Pages

Re: Doing multiple joins on one table
... it doesnt work, it returns always the same max countfor all the rows ... CREATE TABLE GameYellows( ... LEFT OUTER JOIN GameYellow AS y ON y.Player_ID = p.id ...
(microsoft.public.sqlserver.mseq)
Re: Doing multiple joins on one table
... AUTO_INCREMENT is not a recognised keyword in SQL Server. ... using a different DBMS, you might try finding a group for that DBMS in ... LEFT OUTER JOIN GameYellow AS y ON y.Player_ID = p.id ...
(microsoft.public.sqlserver.mseq)
Re: OUTER JOIN possible (and simple) using matlab indexing?
... Tim Booher wrote: ... <SNIP how to do outer join ... ...
(comp.soft-sys.matlab)
RE: [PHP] getting from one table listing from another
... FROM table a LEFT OUTER JOIN table b ... Just follow the order tedd, a is on the left and b is on the right ... FROM table a INNER JOIN table b ...
(php.general)