RE: [PHP] getting from one table listing from another
[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)
.
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) - FW: [PHP] getting from one table listing from another
... Question -- is it redundant to say: ... FROM table a LEFT OUTER JOIN table b ... this differently so for clarity you should always be very specific. ...
(php.general) - Re: Relational question
... left outer join ... >) as AB inner join ( ... >>Let's look at the first LEFT JOIN query: ... >>which we'll refer to collectively as and the constituent queries ...
(microsoft.public.sqlserver.programming) |
|
