First, I would like to thank everyone for their replies to my previous
difficulty understanding SQL. I have reorganized my database as below. I can
get the right reply if I ask for the names of everyone in one specific city
and state (ie Atlanta, Georgia). However, I don't seem to have the right SQL
syntax to get the names of everyone in two cities in one state (ie
Baltimore, Maryland and Olney, Maryland) or two cities and two states (ie
Atlanta, Georgia and Baltimore, Maryland). Any suggestions?
TablePeople
[Name]
TableStates
[State]
TableCities
[City]
TableLocation
[TableStates-ptr] [TableCities-ptr]
TableHomes
[TablePeople-ptr] [TableLocation-ptr]
Gerald
-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
©2000 Gerald Harden |
