I have a table name (master1). In this tabel I have all type master like account ledger, account group, item master, item group masters, salesman master, salesmanmaster group etc.
I can make sub group in main group also which mastertype code is equal main group.
now I want a query to select all account ledger of sundry debtors & sundry creditors in their sub group.
pls help me