Select z databazi s relaci 1:N

[Honza Pazdziora]

On Fri, Dec 07, 2001 at 03:47:45PM +0100, Zdeněk Böhm wrote:

> > Tak to bude marne. Ale muzete vyzkouset ten druhy napad,
> > s outer joinem.
> 
> Vidim to cerne, i tam jsem pomoc hledal. Je tam psane, ze MySQL podporuje

To mne prekvapuje. Kde "tam"?

> join velmi nedokonale a to nasledujici typy (nebo jak to mam nazvat..) inner
> join (s poznamkou, ze to pouze nahrazuje carku mezi jmeny tabulek v FROM),
> left join a natural left join. Pokud jsem dobre pochopil, zadna z techto se
> k tomu nehodi a o outer join tam nabylo ani slovo :-(
> Nejde to jeste nejak jinak, pokud tedy pominu zmenu databazoveho systemu...

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOIN

6.4.1.1 JOIN Syntax

MySQL supports the following JOIN syntaxes for use in SELECT
statements: 

table_reference, table_reference
table_reference [CROSS] JOIN table_reference
table_reference INNER JOIN table_reference join_condition
table_reference STRAIGHT_JOIN table_reference
table_reference LEFT [OUTER] JOIN table_reference join_condition
table_reference LEFT [OUTER] JOIN table_reference
table_reference NATURAL [LEFT [OUTER]] JOIN table_reference
{ oj table_reference LEFT OUTER JOIN table_reference ON
conditional_expr }
table_reference RIGHT [OUTER] JOIN table_reference join_condition
table_reference RIGHT [OUTER] JOIN table_reference
table_reference NATURAL [RIGHT [OUTER]] JOIN table_reference

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
   .project: Perl, DBI, Oracle, MySQL, auth. WWW servers, DBD::XBase.
------------------------------------------------------------------------