top_ancestor_key1和:top_ancestor_key2,即代码FROM genealogyconnect_by_root parent_key2 as top_ancestor_key2, parent_key1, parent_key2, child_key1, child_key2, level
FROM genealogyconnect_by_root parent_key2 as top_ancestor_
我有一张桌子,是我自己做的.我的样本表是这样的+--------+---------+------+-----+---------+-------+SELECT parent, child AS '1st Level' FROM genealogy WHERE parent=1;
SELECTa.parent, b.child AS '2nd Level' FROM (SELECT * FROM <e