Re: [SQLObject] left join with subquery and WHERE

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

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)

   Currently it's impossible to do with SQLObject as it assumes both sides
of a JOIN are table names, not a subselect. That could be fixed.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.