Select the DC/Baltimore neighborhood that you would like to view: <% //String sql2 = "SELECT CityName from Cities Where CityName != ? Order by CityName"; String sql2 = "SELECT CityName, Latitude, Longitude, Zoom FROM ( SELECT distinct a.CityName, a.Latitude, a.Longitude, a.Zoom from Cities a, Bars b where a.uid = b.city_uid UNION ALL SELECT distinct a.CityName, a.Latitude, a.Longitude, a.Zoom from Cities a where a.CityName = ?) c order by c.CityName"; PreparedStatement ps2 = Conn.prepareStatement(sql2); //ps2.setString(1, "Wheaton"); ps2.setString(1, "All Bars"); ResultSet RS2 = ps2.executeQuery(); int j = 0; // Return results to the HTML page while (RS2.next()) { j = j +1; if (i == 1) {%> <%=RS2.getString(1)%><%} else {%> <%=RS2.getString(1)%><%} } //CLEAN UP ps2.close(); RS2.close(); %>     

Or, view a list view a list of bars that carry Hook & Ladder.