如何从此数据库中获取一个人的国家/地区？

Question

我在给定数据库的作业中遇到了非常糟糕的时光，Mysql 上的假模拟器。我的问题是，我需要一个查询来从客户的国家/地区获取数据，但客户的表只包含城市数据。表格是：

tbl_Client:
/ ID*
/ Name
/ Birthday
/ ID_City (FK)
tbl_City:
/ ID_City *
/ vchCityName
/ ID_State (FK)
tbl_State:
/ ID_State *
/ vchStateName
/ ID_intRegion (FK)
tbl_Region:
/ ID_Region *
/ vchRegionName
/ ID_Country (FK)
tbl_Country:
/ ID_Country *
/ vchCountryName

所以，我的问题是，我如何让客户的国家/地区将其与其他数据进行比较？（最大的问题是将客户的国籍与他们喜欢的音乐家进行比较，但我似乎无法管理的是客户部分）。我正在尝试一些非常基本的东西，但它不起作用。

(...)tbl_Client CL, tbl_City CT, tbl_State ST, tbl_Region R, tbl_Country C
WHERE CT.ID_City = ST.ID_City 
AND ST.ID_Region = R.ID_Region 
AND R.ID_Contry = C.ID_Contry

然后我试着比较一下C.ID_Country，嗯，我尝试了很多东西，但仍然一无所获......如果有人能在这方面启发我，我将不胜感激。

非常感谢大家！

Answer 1

有了这个，您可以获得所有相关的数据

select tbl_Client.*, tbl_City.*, tbl_State.*, tbl_Region.*, tbl_Country.*
from tbl_Client
inner join tbl_City on tbl_Client.ID_City = tbl_City.ID_City
inner join tbl_State on tbl_State.ID_State = tbl_City.ID_State
INNER join tbl_Region on tbl_Region.ID_Region = tbl_State.ID_Region
INNER join tbl_Country on tbl_Country.ID_Country =tbl_Region.ID_Country; 

如果您需要客户端 ID 的国家/地区，例如 ID = 3

select tbl_Client.* , tbl_Country.*
from tbl_Client
inner join tbl_City on tbl_Client.ID_City = tbl_City.ID_City
inner join tbl_State on tbl_State.ID_State = tbl_City.ID_State
INNER join tbl_Region on tbl_Region.ID_Region = tbl_State.ID_Region
INNER join tbl_Country on tbl_Country.ID_Country =tbl_Region.ID_Country
where tbl_Client.ID = 3;