Search the Community
Showing results for tags 'two tables'.
Found 1 result
-
Problem: I want it to only display the vacancy if it's in the location specified. Table "hotel" knows the "location" but table "vacancy" does not (however it does have the same exact hotel name). i have this right now (which only works on table vacancy): "SELECT * FROM vacancy WHERE price > $minprice AND price < $maxprice" ---------------------------below are the mysql table structure and user supplied information-------------------------- Prospective Hotel Guest supplies: Location Max Price/Min Price Minimum Price Quality of Hotel table hotel primary column1 = hotel name column 2 = hotel owner column 3 = location of hotel column 4 = quality of hotel table vacancy (not primary) column 1 = hotel name column 2 = room # column 3 = price
