Re: MySQL stmt

2001-06-20 Thread Benjamin Pflugmann
Hello. On Tue, Jun 19, 2001 at 11:30:34AM +0530, [EMAIL PROTECTED] wrote: [...] > This is my sql statement: > mysql> select count(*),travel.nome_hotel,travel.tour_operator, > city.city,travel.vitofferta from travel,city where city.id=travel.cityid > group by travel.nome_hotel limit 5; > > The re

MySQL stmt

2001-06-18 Thread Adrian D'Costa
Hi, Thanks for assisting me in my earlier query. I never had the time to try it out as my office needs keep changing. In connection to my earlier question, this is just an extension :) The hotel names repeat in the travel table. My travel table's required fields from the hotel table are: nom