I am trying to find patrons who have a ticket to every concert in our orchestral season. They would have to have multiple subs in order to accomplish this as there is no package that includes them all. Is there a why to do this with an extraction?
I already tried finding it with the a script, but I came up with 6 patrons and was told that can't be correct. I queried the vs_ticket_history view, and filtered by season.
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
I tried IN and HAS and both gave me this error:
What does Show Query produce?
I believe the error is due to too many selections for the one criteria. You might be able to use the secondary criteria to avoid the issue.
That might break the query, can't remember on the top of my head how those sort out, but I think it might turn into a functional OR.
Thank you!