How to Fetch all company ledger list?

Dear Experts.,
i want to display all company ledger list using tally sql query., i am using following sql query in tally "SELECT $name from ledger", but it will display only selected company ledger list rest company ledger list not shown., Is there any way to display all company ledger list using tdl collection., i am new to tdl please give me a solution.,

Thanks.,

 

[Collection : GroupCompanyLedgerCollection]

Collection: MultiComp: GrpCmpColl

[Collection : MultiComp]

Type : Ledger
Fetch: Name, closingbalance
Compute: Cmp: $$LoopCollObj:$Name

[Collection: GrpCmpColl]

Type : Company
Fetch:Name

Hope this collection will help you.,

 

Thanks for your code., This is what i am looking for., once again i thank you.,