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?