[SQLObject] Can table be joined with itself?

[Marcin W. <wo...@un...>]

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 =3D B.id AND A2.b_id =3D B.id AND A1.x =3D 123 AND A2.x =3D=
 234;

Marcin

--=20
Marcin Wojdyr  |  http://www.unipress.waw.pl/~wojdyr