Greetings,
I have a output set consisting of a Constituency End Date that is looking for a NULL value. I have set up the fields where the data select is !.end_dt looking at the view VXS_CONST_CUST. The where area is defined as:
constituency = <<p4>> and end_dt is null
The output set has this and nothing else. A search HH is checked. I receive an error message that states:
The columns constituency and end_dt are ambiguous. I was peering into RP_RUNQUERY and noticed that there is only one table alias allowed for the work table, hence the error. Has anyone worked out the solution to something like this?
Hi Troy,
I thought I could help you but I am unable to replicate the error.
Is there anything else in the Data From column besides VXS_CONST_CUST? It seems like if the procedure is looking at a single view there wouldn't be any chance of more than one field having the same name.
Jared