Join two table fields to one field
Posted on 2004-04-17
I have two tables "Locations" and "Hotel". i wanna join:
Locations.Locations and Hotel.Hotel
in one field. so you can select from a list with both the values from locations and hotel. Im using Microsoft Access by the way. i have tried with SELECT Locations.ID, Locations.Locations, Hotel.ID, Hotel.Hotel FROM Locations, Hotel;
but that doesnt seem too work i get alot of the same values. Im only working in Access so i only have the option of creating one single SQL query. i have tried with union aswell but it doesnt work either...