On Fri, May 14, 2010 at 06:22:05PM +0400, Oleg Broytman wrote: > On Fri, May 14, 2010 at 03:37:46PM +0200, Imre Horvath wrote: > > select * from pricegroups > > left join (select * from products_pricegroups > > where products_pricegroups.product_id=1) as a > > on (pricegroups.id=a.pricegroup_id)
Does the query work at all in MySQL? Oleg. -- Oleg Broytman http://phd.pp.ru/ p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------------ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss