I need to update my query element to show the next season's shows for confirmation letters. I was told to:
You will simply want to update that from LVS_TICKET_HISTORY to T_TICKET_HISTORY anywhere it is referenced.
I did this then I got this error message when trying to run the output:
SyntaxFromSQL caused these errors: SQLSTATE=42000 Microsoft OLE DB Provider for SQL Server
The column 'prod_season_no' was specified multiple time for 'b'. Execut dbo.RP_RUN_QUERY;1 @query_no=336, @list_no=0
The DATA FROM column has this (I changed it back to tkt_hist)
(select b.*,c.description as 'venue',p.prod_season_no from lvs_tkt_hist b JOIN t_perf p on b.perf_no = p.perf_no JOIN t_facility c on p.facility_no = c.facil_no)
How do I change it without error?
Hi Adria,
T_TICKET_HISTORY has a prod_season_no field in it all ready and this is interfering with p.prod_season_no in your DataFrom query.
Try this: (I have used the secure View rather than the Table)
(select b.*, c.description as 'venue' from VS_TICKET_HISTORY b JOIN t_perf p on b.perf_no = p.perf_no JOIN t_facility c on p.facility_no = c.facil_no)
RegardsSandra