SELECT Business.BusName, Business.Industry, Business.[E-mail], Business.[Tel Code], Business.[Tel No], Business.Fax, Business.City, [Bus-Serv].ServiceId<BR>FROM Business INNER JOIN [Bus-Serv] ON Business.BusID = [Bus-Serv].BusID<BR>"where [Bus-Serv].Id = "& Request.form("Service") &_<BR>AND Business.City = "& Request.form("City")<BR><BR>Well this is how I've planned to make a query that will list business details according to a city and srevice requested by a user.<BR><BR>This is a mission critical thing for me. The sql statement is needed soon.