Multiply Queries

I am try to do all in one queries which has two queries imbedded into.

"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