I'm trying to make a select that returns the journeys where a certain user is inserted, but I'm getting this error, does anyone know why?
Select Distinct J.JourneyId, J.JourneyName, S.SubscriberID,SUB.SubscriberID
FROM _Journey J
INNER JOIN _JourneyActivity JA ON JA.VersionID = J.VersionID
INNER JOIN _Sent S ON JA.JourneyActivityObjectID = S.TriggererSendDefinitionObjectID
INNER JOIN _Subscribers k ON S.SubscriberID = k.SubscriberID
WHERE SUB.SubscriberID='0016g00001AEHcyAAH'