Planet Earth Solutions P. Ltd.

select LEDGERNAME from ledgers
where ((ledgername in
(select distinct(paymentledger) from payment)
or ledgername in
(select distinct(ledgername) from payment))
or (ledgername in
(select distinct(receiptledger) from receipt)
or ledgername in
(select distinct(ledgername) from receipt))
or (ledgername in
(select distinct(debit) from journal)
or ledgername in
(select distinct(credit) from journal))
or (ledgername in
(select distinct(debit) from contra)
or ledgername in
(select distinct(credit) from contra)))
and groupname in
(select groups.groupname from groups, primarygroups
where primarygroups.primarygroupname =
groups.primarygroupname
and primarygroups.primarygroupnameenglish in
('Share Capital A/C', 'Loan Investment A/C',
'Saving Deposit A/C', 'Fixed Deposit A/C',
'Current Deposit A/C', 'Reccurring Deposit A/C'))
order by ledgername