• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.

YASHR - Yet Another Access SQL Help Request

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    YASHR - Yet Another Access SQL Help Request

    Code:
    SELECT Date_Lookup.Date,  PQuery.SumOfHours
    FROM Date_Lookup,
    (
    SELECT Hours.Date, Sum(Hours.Hours) AS SumOfHours
    FROM Hours
    WHERE (((Hours.ActCode)<>"UNAA" Or (Hours.ActCode)<>"SICK" Or (Hours.ActCode)<>"HOLI") AND ((Hours.Shift)="DAY") AND ((Hours.Area)="HYDRO"))
    GROUP BY Hours.Date
    ) as PQuery
    LEFT JOIN PQuery ON Date_Lookup.Date = PQuery.Date
    WHERE (((Date_Lookup.Date_Year)=2008))
    Any ideas on where the error is in this?

    I get "syntax error in JOIN operation".

    Thanks in advance,
    Sockpuppet

    #2
    try

    Code:
    SELECT Date_Lookup.Date,  PQuery.SumOfHours
    FROM Date_Lookup
    LEFT JOIN
    (
    SELECT Hours.Date, Sum(Hours.Hours) AS SumOfHours
    FROM Hours
    WHERE (((Hours.ActCode)<>"UNAA" Or (Hours.ActCode)<>"SICK" Or (Hours.ActCode)<>"HOLI") AND ((Hours.Shift)="DAY") AND ((Hours.Area)="HYDRO"))
    GROUP BY Hours.Date
    ) as PQuery
     ON Date_Lookup.Date = PQuery.Date
    WHERE (((Date_Lookup.Date_Year)=2008))
    not sure you need the as before the PQuery

    Code:
    ) as PQuery
    Code:
    ) PQuery
    Coffee's for closers

    Comment


      #3
      Originally posted by Spacecadet View Post
      try

      Code:
      SELECT Date_Lookup.Date,  PQuery.SumOfHours
      FROM Date_Lookup
      LEFT JOIN
      (
      SELECT Hours.Date, Sum(Hours.Hours) AS SumOfHours
      FROM Hours
      WHERE (((Hours.ActCode)<>"UNAA" Or (Hours.ActCode)<>"SICK" Or (Hours.ActCode)<>"HOLI") AND ((Hours.Shift)="DAY") AND ((Hours.Area)="HYDRO"))
      GROUP BY Hours.Date
      ) as PQuery
       ON Date_Lookup.Date = PQuery.Date
      WHERE (((Date_Lookup.Date_Year)=2008))
      not sure you need the as before the PQuery

      Code:
      ) as PQuery
      Code:
      ) PQuery




      Many thanks. Legend.

      Comment


        #4
        Originally posted by Sockpuppet View Post


        Many thanks. Legend.
        no probs
        Coffee's for closers

        Comment

        Working...
        X