I appreciate everyone’s eyes on this. I wish I could explain it, but without changing anything, that query works fine today… Maybe I was running into a server-side bug or load problem that is no gone. Thanks all!
@kvbe - I am bringing in SUB_Project_ID from the ‘ACTIVITY’ table with this line in my select statement: ACTIVITY.Sub_Project_ID AS "Sub Project ID". It is the one I am trying to JOIN on. @Bjornar Brekka I’ll try this!
Unfortunately, nothing more than this from the logs: “SQL_EXPRESSION - (Server Application Error): Sql Expression is wrong”. It is first time I have tried to do a JOIN on a column created from the prior JOIN command. That shouldn’t be an issue in IFS, right?
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.