I've 3 tables :-

ACGLMST -> General Ledger codes,
Fields AcCode, Description, OpnBal

ACTRANS -> Transaction file, Parent of Actr2,
Fields AcCode, Date, Amt, DrOrCr

ACTR2 -> Child of Actrans, 1 to Many Relation,
Fields Actranscode, AcCode, Date, Amt, DrOrCr

I need report in following format

Ledger Code 1     "Scb Bank A/c"        Opening Balance 145,000.00
==================================================================

AcCode   Description    Date        DrAmt       CrAmt

12       Xyz Customer   01/01/99    50,000.00    -
13       Claims         15/02/99     -          1560.00

Ledger Code 2 etc. etc.

By writing a procedure, i can create a cursor, but is there any way to retrieve this info with 1 sql command only.. (which I can use in report)...

TIA