On Fri, May 14, 2010 at 04:43:46PM +0200, Imre Horvath wrote:
> sqlite> select * from pricegroups
> ...> left join (select * from products_pricegroups
> ...> where products_pricegroups.product_id=1) as a
> ...> on (pricegroups.id=a.pricegroup_id);
I don't understan what is aliased as 'a'. The subquery? I tried to take
it into parentheses:
select * from pricegroups
left join ((select * from products_pricegroups
where products_pricegroups.product_id=1) as a)
on (pricegroups.id=a.pricegroup_id);
bug got an error:
SQL error near line 1: no such column: a.pricegroup_id.
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
