We are defining prompts in Derived table for the object, getting error message invalid prompt definition when validating SQL.
Below is the code
Select table.column1 from table
where table.colum2 ='X'
And table.column1 in @prompt(......)
If we use same prompt definition individually it is working fine but it throwing error in derived table.
Can any one throw some insight on this.