select
city0_."nID" as nID1_0_0_,
region1_."nID" as nID1_1_1_,
city0_."sName" as sName2_0_0_,
city0_."nID_Region" as nID_Regi3_0_0_,
region1_."sName" as sName2_1_1_
from
"City" city0_
inner join
"Region" region1_
on city0_."nID_Region"=region1_."nID"