[FONT=Courier New]Hi guys,
I am new to SQL and I am learning fast, but I need some pointing in the right direction here, as I am not finding easily the answer to what should be a simple question.
Say that we have 3 Tables with the following relationships:
| Cities | | States | | Countries |
| id | --->| id | --->| id |
| name | | | name | | | name |
| state_id |---- | country_id |---- | |
My question is,
How do I structure a Query that would return all the Cities
that belong to a certain Country?
I look forward to some feedback.