Hi all

I have to find out the root+1 of each record in a hierarchial table.

Is that possible using SQL. The data contained is for an Accounts tree, so the root nodes are Manufacturing A/c., Profit & Loss A/c., Balance Sheet. The Root+1 nodes will be Debit, Credit (for manu. /a.c), Debit, Credit (for P&L), Asset and Liability (for Bal. Sheet).

The aim is to find out the Debit, Credit, Asset or Liability status of each account.

Please advise.