I am try to do all in one queries which has two queries imbedded into.
If is not work at all it is just asking that it is invalid join to the main query
Thanks
Sean
Code:
"SELECT Filter_ID, Channel, SpeedBands, Filter_Channel, Filter_type
FROM
(SELECT [Tbl_Lookup_Channels].[ID] AS Channel, [Tbl_Lookup_SpeedBand].[ID] AS SpeedBand
FROM Tbl_Lookup_Channels, Tbl_Lookup_SpeedBand)
LEFT JOIN
(SELECT [Site_ID] AS Filter_ID, [Channel] AS Filter_Channel, [Type] AS Filter_SpeedBand
FROM Tbl_SiteResults
WHERE Site_ID=" & ID &")
ON ((SpeedBand = Filter_Speedband) AND (Channel = Filter_Channel))
GROUP BY Filter_ID, Channel, SpeedBands, Filter_Channel, Filter_type
HAVING Filter_Channel Is Null AND Filter_type Is Null
ORDER BY Channel, SpeedBands;"
If is not work at all it is just asking that it is invalid join to the main query
Thanks
Sean