SELECT Customer.Customer_id, Customer.Customer_name, Visits.visit_date,; Visits.location_id, Visits.Visits_id, 0 AS vcount; FROM ; hpmg!Customer ; LEFT OUTER JOIN hpmg!Visits ; ON Customer.Customer_id = Visits.Customer_id; WHERE YEAR(Visits.visit_date) = ( ?lnYear) INTO CURSOR curHold_1
SELECT Customer.Customer_id, Visits.visit_date, Visits.location_id,; COUNT(*) AS vcount; FROM ; hpmg!Customer ; LEFT OUTER JOIN hpmg!Visits ; ON Customer.Customer_id = Visits.Customer_id; WHERE YEAR(Visits.visit_date) = ( 2015 ); GROUP BY Customer.Customer_id, Visits.visit_date, Visits.location_id; HAVING ( vcount ) > ( 1 ) INTO CURSOR curHold_2
SELECT curHold_1.Customer_id, curHold_1.Customer_name, curHold_1.Visits_id,; curHold_1.visit_date, curHold_1.location_id; FROM ; curHold_1 ; INNER JOIN curHold_2 ; ON curHold_1.Customer_id = curHold_2.Customer_id; WHERE ( curHold_1.Customer_id = curHold_2.Customer_id; AND curHold_1.visit_date = curHold_2.visit_date ); AND curHold_1.location_id = curHold_2.location_id...I suppose I could leave it this way but I'd really like a cleaner way to do it.