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.