Self Joins

Hi,

my Problem is a Type of SQL Query i want to perform with QueryBuilder:
The Query contains 2 references of the same table

An Example:
there is a table "node" with the following fields
oid - key
parent - references node
name - string

SELECT *
FROM node AS child INNER JOIN node AS parent ON child.parent_oid =
parent.oid
WHERE parent.oid=1234 AND child.name LIKE "A%"

Important is that i must access attributes of different records of the
same table.

Any idea how th do this with the querybuilder?

Thanks

Jan Schnabel

--------------------------------------------
itCampus Software und Systemhaus GmbH
Leipzig Halle Wittenberg

Nonnenstr. 42
04229 Leipzig

[email protected]

Tel:  +49. 341. 4 92 87 32
Fax:  +49. 341. 4 92 87 01

http://www.itcampus.de

Amtsgericht Leipzig HRB 15872
Geschäftsführer Andreas Lassmann
 --------------------------------------------