Paul
03/01/2022, 2:43 PMSELECT
sja.segment,
sjct.constraint_type,
sjac.constraint_value,
relation,
sja.segment,
sjct.constraint_type,
sjac.constraint_value
FROM signal_journey_audience_constraint_relations
JOIN signal_journey_audiences sja ON signal_journey_audience_constraint_relations.audience_id = sja.audience_id
JOIN signal_journey_audience_constraints sjac ON signal_journey_audience_constraint_relations.constraint_id = sjac.constraint_id
JOIN signal_journey_constraint_type sjct ON sjac.constraint_type_id = sjct.constraint_type_id
Steve
03/02/2022, 10:14 PMPaul
03/02/2022, 10:15 PM