Skip to main content

ExecuteSQL Multi Join Relations

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 )