Hello Community,
I am trying to apply the SQL 'where' clause with the In-Database tool as follows:
race_year = 2019
where circuit_id < 70
However, the SQL clause doesn't appear to be supported.
Any thoughts on how to implement T-SQL in the In-Database tool
Solved! Go to Solution.
@carltonp the In-DB Filter tool itself acts as a 'WHERE' clause and so you just type into the filter everything you would normally place after this. Judging from your request your custom filter should perhaps just be
race_year = 2019
AND
circuit_id < 70