Mark Nelson 11/4/2015 12:52:44 PM

Creating joins with mismatched Column Names

While I know that this is not technically possible this is the issue I am faced when developing a report.

Two views and a table all reference the same data which is what I need however when I go to join them I receive Invalid Joins, so I looked at the naming and I have

three different versions. I am creating this report within Any view, however I believe this would occur regardless of the UI I am working with.

 

I would love to hear of any possible solutions.

 

 

Thank you

 

Mark

 

Version: GP 2010
Section: Dynamics GP, SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3