Connecting multiple Query to one Grid
Posted on 2006-10-19
Backend - Progress Database
Front End - Delphi
ODBC - SQL92
I have lots of Restriction using SQL commands with Progress Database, since it doesn't support all of them. For example the below Query doesn't work.
SELECT t1.tr_effdate, COUNT(t1.tr_effdate) AS DayCount, (SELECT COUNT(*) FROM tr_hist t2
WHERE t2.tr_effdate BETWEEN '1 Jun 2006' AND t1.tr_effdate) AS MonthToDate
FROM tr_hist t1
GROUP BY t1.tr_effdate
ORDER BY t1.tr_effdate
My Questions now,
I want to used multiple Queries and display the data on one TDBGrid. I will have a key field in each query .
Is this possible , if so can someone explan with a small example.
Let me know if you need any other details.