>SELECT '1' AS SortKey, 'Family History' AS Group, ; > demox AS Extra1, demoy AS Extra2, demoz AS Extra3, ; > SomeDate AS Date1, SomeDate AS Date2, ; > HealthNo, FamHist AS Descr, FROM TableA ; > UNION SELECT '2' AS SortKey, 'Past History' AS Group, ; > demox AS Extra1, demoy AS Extra2, demoz AS Extra3, ; > SomeDate AS Date1, SomeDate AS Date2, ; > HealthNo, PastHist AS Descr FROM TableA ; > UNION SELECT '3' AS SortKey, 'Allergies' AS Group, ; > demox AS Extra1, demoy AS Extra2, demoz AS Extra3, ; > SomeDate AS Date1, SomeDate AS Date2, ; > HealthNo, Allergy AS Descr FROM TableA ; > UNION SELECT '4' AS SortKey, 'Conditions' AS Group, ; > '' AS Extra1, '' AS Extra2, '' AS Extra3, ; > RecordDate AS Date1, ResolvedDate AS Date2, ; > HealthNo, Condition AS Descr FROM TableB ; > UNION SELECT '5' AS SortKey, 'Regimans' AS Group, ; > '' AS Extra1, '' AS Extra2, '' AS Extra3, ; > StateDate AS Date1, EndDate AS Date2, ; > HealthNo, Regiman AS Descr FROM TableC ; > UNION SELECT '6' AS SortKey, 'Consultations' AS Group, ; > '' AS Extra1, '' AS Extra2, '' AS Extra3, ; > ReferDate AS Date1, {} AS Date2, ; > HealthNo, Consult AS Descr FROM TableD ; >ORDER BY HealthNo, SortKey ; >INTO CURSOR TmpData >>