*!* Table1 Customers *!* Example: 1; Winegarden, Cindy, 27; NC CREATE TABLE Customers (CustID, I, CustomerName C(x), CustomerCityID I, CustomerStateID C(2)) *!* Table2 Cities *!* Example: 27; Durham CREATE TABLE Cities (CityID I, CityName C(x)) *!* Table3 States *!* Example: NC; North Carolina CREATE TABLE States (StateID C(2), StateName C(x)) SELECT ; Customers.CustID, Customers.CustomerName, ; Cities.CityName, ; States.StateName ; FROM Customers ; LEFT JOIN Cities ON Customers.CityID = Cities.CityID ; LEFT JOIN States ON Customers.StateID = States.StateID>Let me play Devil's advocate. Sometimes normalization leads to having city lookup tables and state lookup tables. Some like to store the Id which makes it easier to to updates. Some prefer to store the city and state directly.