Greetings,

I have three tables as follows

Receipt
ReceiptLine
ReceiptPayment

One Receipt row can have multiple receiptline rows and multiple
ReceiptPayment rows.

Now I use three stored procedures to retrieve data from each table. It
is becoming very slow when I have to retreive more records.

How would I write one stored procedure that will retrieve all three.

Thanks!

Muthu Annamalai