Now there is No connect by Prior or any analytic functions available for this . THIS NEEDS TO BE DONE ONLY THROUGH TRADITIONAL SQL STATEMENT .
Are you using Informix, the dead product?

Why don't you post the create and insert statements for all tables?

Tamil