+ Reply to Thread
Results 1 to 1 of 1

Joins not working in SQL VBA

  1. #1
    Registered User
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2010
    Posts
    1

    Joins not working in SQL VBA

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Noob Joins
    By dogmeister in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-15-2015, 03:54 PM
  2. [SOLVED] Getting JOINs to work in MSDASQL
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 11-27-2014, 04:40 AM
  3. [SOLVED] Joins in VBA without SQL
    By kravi88 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-07-2014, 12:34 PM
  4. SQL Multiple Joins
    By johncassell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2011, 12:33 PM
  5. Multiple joins in SQL statement in excel VBA.
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2010, 01:02 AM
  6. Joins in excel
    By fralo in forum Excel General
    Replies: 5
    Last Post: 03-03-2008, 12:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1