Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Sign Up Now!Log In
acabot 10/20/2016 4:52:54 PM

Trying To Figure Out SQL Query Behavior

I have this query:


select e1.[Division] AS 'Division', Sum(e1.[July Emp Count]) AS 'Month1 Emp Count', Sum(e2.[Aug Emp Count]) AS 'Month2 Emp Count', Sum(e3.[Sept Emp Count]) AS 'Month3 Emp Count'

into #emp_total

from #emp e1

JOIN #emp2 e2 ON e1.Division=e2.Division

JOIN #emp3 e3 ON e1.Division=e3.Division

group by e1.division order by e1.Division


select * from #emp_total order by division


The results in the three "Emp Count" columns doubles each time I add one of the JOINs.  Why?

For example, in this result:

Division Month1 Emp Count Month2 Emp Count Month3 Emp Count
120      68                68                76

These three counts SHOULD be 17, 17 and 19

Version: GP 2013
Section: 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