Re: [SQLObject] left join with subquery and WHERE

[Oleg B. <ph...@ph...>]

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/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.