Hi guys,
I have a really weird issue that I have been breaking my head over the last couple of days. I am trying to execute the follwoing sql code in VBA. However, A join C works, but A join C join B does not. B works indeendednlty, but not when together. A join B works too.
sql1 = " SELECT A.USERNAME, A.O_PLANNED, C.R_PLANNED FROM " & _
" (SELECT P.USERNAME, COUNT(P.OUTLET_ID) AS O_PLANNED " & _
" FROM (SELECT DISTINCT USERNAME, OUTLET_ID FROM [" & DailyTourPlan & "] ) P GROUP BY P.USERNAME) A " & _
" INNER JOIN " & _
" (SELECT R.USERNAME, COUNT(R.ROUTE) AS R_PLANNED FROM " & _
" (SELECT DISTINCT USERNAME, ROUTE FROM [" & DailyTourPlan & "] ) R GROUP BY R.USERNAME) C " & _
" ON A.USERNAME = C.USERNAME "
' & _
" INNER JOIN " & _
" (SELECT Q.USERNAME, COUNT(Q.DATE) AS D_PLANNED FROM " & _
" (SELECT DISTINCT USERNAME, DATE FROM [" & DailyTourPlan & "] ) Q GROUP BY Q.USERNAME) B " & _
" ON A.USERNAME = B.USERNAME "
PJP Summary sheet is where I want to paste my data. The macro that I am using is the DisplaySummary sub.
Bookmarks