Re: [SQLObject] Can table be joined with itself?

[Andrew B. <and...@pu...>]

On Fri, Aug 20, 2004 at 02:14:46PM +0200, Marcin Wojdyr wrote:
> Hello,
> 
> Is it possible to make a query like this in SQLObject?
> SELECT B.id FROM B, A as A1, A as A2
> WHERE A1.b_id = B.id AND A2.b_id = B.id AND A1.x = 123 AND A2.x = 234;

This might work:

B.select('A1.b_id = B.id AND A2.b_id = B.id AND A1.x = 123 AND A2.x = 234',
         clauseTables=['A as A1', 'A as A2'])
     
-Andrew.