I expect the SQL code must be like select [Buildings Drawing].[ID], [Buildings Drawing].[Area (I)], [HoT].[Height (I)], [HoT].[Center Easting (I)], [HoT].[Center Northing (I)], Avg ([Hot].[Height (I)]) as AvH, [Buildings Drawing].[Area (I)] * Avg ([Hot].[Height (I)]) FROM [Buildings Drawing], [HoT] where Contains ([Buildings Drawing].[ID], ??????? ) group by [Buildings Drawing].[ID] -- what to put in place of ???? , the geom for each pixel coordinate in [Hot], What is the right syntaxis ? Thank you in advance for guiding.
|