Multi Join ExecuteSQL Statement

Trip::Countries (Safari database)

/ This show days in destination /

ExecuteSQL ( "SELECT DISTINCT(a.Name), SUM(ii.x_Days)

FROM Area AS a

INNER JOIN  Destination d

ON d.\"_kf_area\" = a.\"__kp_Area\"

INNER JOIN  Accommodation accom

ON accom.\"_kf_Destination\" = d.\"__kp_Destination\"

INNER JOIN  ItineraryItem ii

ON ii.\"_kf_Accommodation\" = accom.\"__kp_Accommodation\"

INNER JOIN  Trip t

ON t.\"__kp_Trip\" = ii.\"_kf_trip\"

WHERE t.\"__kp_Trip\" = ? GROUP BY a.Name";"" ;" / " ; Trip::__kp_Trip )

/ This show minus days in destination /

ExecuteSQL ( "SELECT DISTINCT(a.Name)

FROM Area AS a

INNER JOIN  Destination d

ON d.\"_kf_area\" = a.\"__kp_Area\"

INNER JOIN  Accommodation accom

ON accom.\"_kf_Destination\" = d.\"__kp_Destination\"

INNER JOIN  ItineraryItem ii

ON ii.\"_kf_Accommodation\" = accom.\"__kp_Accommodation\"

INNER JOIN  Trip t

ON t.\"__kp_Trip\" = ii.\"_kf_trip\"

WHERE t.\"__kp_Trip\" = ? GROUP BY a.Name";":" ;" / " ; Trip::__kp_Trip )