Another simple SQL query (MS Access)

Solus · #1 (**permalink**) 04-29-04, 05:29

Hi. I'm having trouble doing another SQL query. It needs to compare a height against the average height of a group. If it is larger, than it is shown. I can create the sub query but it returns an error when going to the outer query.

Code:

Select avg(height) 
from Materials 
group by MCode

What is an outer query that would compare a single height against that groups average height and display the rows if the single height is greater?

Solus · #2 (**permalink**) 04-29-04, 05:39

oh yeah, another thing. My outer query select can only have 2 columns (material, height)

r937 · #3 (**permalink**) 04-29-04, 08:00

Code:

select material
     , height
  from Materials ZZ
 where height
     > ( select avg(height)
           from Materials
          where MCode = ZZ.MCode )

Internet Services

Web Development

Digital Marketing

Consumer Tech