How to Input Tables to sql dynamically

Hi All,

           How to add tables dynamically to a sql inorder to fetch data or to update or two  add joins between tables in UI

Hi Karthik,

You shouldn't do that. The SQL Statement needs a fixed output, so unless the SELECT list is still the same, it's not possible (you'll get errors). However, if you want to dynamically add SQL to an SQL query, you use an input parameter and set its "Expand Inline" Property to True. Table and column names are to be specified like in the query itself (so {Entity}.[Attribute]).