I need to call upon you SQL gurus to please help me figure this out
I have edited the OOTB Actuals by Transaction type query to include the charge code (id) from ppa_wip. This works fine. However, I now need to add the charge code name from prchargecode. The charge_code column in ppa_wip = the prexternal id in prchargecode.
Due to the length of the query, I have attached it in Word and have highlighted what I have attempted in order to get the charge code name from prcharge code to work. You can see in the lines above it, I was able to add the charge code from ppa_wip but this entails bringing in a new table, so I am obviously not doing something right. This is a multi dimensional portlet. I have read many posts on here, but haven't seen one that helps me
I keep getting the typical NPT-0103 error: Error when trying to execute the query. Native message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'code' (then it posts the NSQL text) . Can you help me figure out what is wrong or if I am completely off base and this just cannot be done? Admittedly, I am by far NOT a NSQL genius. I was able to run the select statement with the inner joins successfully in the query analyzer.
We are a SQL environment, 13.3