count

Hej Eksperter
Jeg har den her select:

SELECT MAX_HOTEL.*, MAX_HOTEL_BOOKING.amount_sincle, MAX_HOTEL_BOOKING.amount_dbl, MAX_HOTEL_BOOKING.amount_sincle_smoker, MAX_HOTEL_BOOKING.amount_dbl_smoker, MAX_HOTEL_BOOKING.payment, MAX_HOTEL_BOOKING.bookfrom, MAX_HOTEL_BOOKING.bookto, MAX_HOTEL_BOOKING.booked_date, MAX_VISITORS.title, MAX_VISITORS.name as visitorname, MAX_VISITORS.company, MAX_VISITORS.country, MAX_VISITORS.smoker, MAX_VISITORS.vegetarian, MAX_VISITORS.anonymise FROM MAX_HOTEL_BOOKING LEFT OUTER JOIN MAX_HOTEL ON MAX_HOTEL_BOOKING.hotelid = MAX_HOTEL.id LEFT OUTER JOIN MAX_HOTEL_BOOKING_VISITORS ON MAX_HOTEL_BOOKING_VISITORS.hotel_booking_id = MAX_HOTEL_BOOKING.id LEFT OUTER JOIN MAX_VISITORS ON MAX_VISITORS.id = MAX_HOTEL_BOOKING_VISITORS.visitor_id WHERE MAX_HOTEL_BOOKING.projectid =16 order by MAX_HOTEL.id

Jeg vil gerne have tilføjet count(MAX_HOTEL_BOOKING.amount_sincle_smoker) as c, til query'en. Kan jeg det uden at få meddelelsen:

not contained in an aggregate function and there is no GROUP BY clause