Updating my JMP table with SQL "AS" statement
Hello,I have to regularly update my JMP file by connecting to my database and running a long manually created SQL query. Until now, I used the "AS" command to match the field names in my database with the simplified name of columns in JMP. After importing the data into a temporary JMP table, my script finished the update by making a join with my working JMP file using the same short column names. ...
claude_bellavan