>>>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 >>>>>>