> Use a union query...the hesp come first or last > > Select * From Fruit WHERE type='hesp' order by colour > UNION > Select * From FRUIT WHERE type <> 'hesp' order by name
Thanks for the speedy response this gave me the error 1221 "Incorrect usage of UNION and ORDER BY". However this did work:- (Select * From Fruit WHERE type='hesp' order by colour) UNION (Select * From FRUIT WHERE type <> 'hesp' order by name): The MySQL is still version 4.1.22 would this be the problem? Whatever, I have a solution now, many many thanks. Charlie
