Hi, I'm having trouble figuring out the syntax for this type of database inquiry. I have three tables:
1) stores, which has a name 2) regions, which has a 2-letter abbreviation 3) store-region, which puts stores in certain regions. I want to pass in a 2-letter region abbreviation, and receive back the names of the stores in that region. So I need to use the results of one query (regions with the abbreviation "NY", say), to get another set of results (store ids with that region id), to get the third set of results (stores names that matched the store ids) Thanks for reading..
