[Zope-DB] how to complement a result set

Andreas Kaiser kaiser at xo7.de
Tue Mar 9 06:37:15 EST 2004


sorry.

--On Dienstag, 9. März 2004 12:32 +0100 Andreas Kaiser <kaiser at xo7.de> 
wrote:

> select m_name, c_name
> from costs, months LEFT OUTER JOIN mc ON (months.m_id = mc.m_id) LEFT
> OUTER JOIN costs ON (costs.c_id = mc.c_id)

should be

> select m_name, c_name
> from months LEFT OUTER JOIN mc ON (months.m_id = mc.m_id) LEFT
> OUTER JOIN costs ON (costs.c_id = mc.c_id)




More information about the Zope-DB mailing list