Hi ,
I used JMP DATAbase Query to query data from tables. the same query worked find until today it suddenly complains of issue of converting char to int. I'm not sure why it worked before and nothing has changed, but now not it is not working. So I started to work on the custom query to find a way to add script to convert. This is my first time with the custom sql query.
how can I convert the t2.[tools] to int in this section of the query? I tried convert() and cast() on it but failed. can someone help?
select
t14.[value] AS [value 1]
LEFT OUTER JOIN [xxx.[xxx_table] t14
ON ( t2.[tools] = t14.[value_id])
