YASHR - Yet Another Access SQL Help Request

[Sockpuppet]

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

[Spacecadet]

try

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

) as PQuery

) PQuery

[Sockpuppet]

try

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

) as PQuery

) PQuery

Many thanks. Legend.

[Spacecadet]

Many thanks. Legend.

no probs