class.cfg.xml question

amy

(decode((select count(right_id) from fpi_right_tree_sorted_v where parent_id = right_id), 0, '0','1')) as hasChildren,lt;class name=quot;xquot;  table=quot;yquot;gt;
lt;id name=quot;idquot; column=quot;right_relationship_idquot;gt;
lt;generator class=quot;incrementquot;/gt;
lt;/idgt;
lt;property name=quot;right_idquot; column=quot;right_idquot;/gt;
lt;property name=quot;parentidquot; column=quot;parent_idquot;/gt;
lt;/classgt;this does select id , rightid from y

i want it to be

select id, rightid, (decode((select count(right_id) from x where parent_id = right_id), 0, '0','1')) as hasChildren,anyone knows how to do it/ formula or sthg?