selecting by average

2004-05-19 Thread Gerald Taylor
I have a table called ratings. It has 3 rows of interest id foreign key to another table quala quality rating u the user who gave that rating (also a foreign key into the users table) Now I would like to select all the unique ids for which the average quality is below 1.5

Re: selecting by average

2004-05-19 Thread Michael Stassen
Gerald Taylor wrote: I have a table called ratings. It has 3 rows of interest id foreign key to another table quala quality rating u the user who gave that rating (also a foreign key into the users table) Now I would like to select all the unique ids for which the average