Is there a simple SQL construction to retrieve the values of all the columns
from a master table and a number of corresponding rows in details table ?
Eg.
1,My first transaction, 10/12/2001, 20
2,My second transaction, 11/12/2001, 9
Where 20 and 9 are number of details rows for each transaction stored in
details table.
I have tried to play with Count(), did not get too far.
Thanks
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
