Multi-table Query

Table: ci column name data type size notes about the data Number Text Text Text Number 11 City ld Code (primary key 35 Name of C ID name Country Code foreign Key to CountryCode) District 20 Population Table: coun data type Text Text notes about the data column name Code Name size Country Code (primary key) street addre ss Asia, Europe, North America, Africa, Oceania, Antarctica, South America 52 Text Text umber Number Number Number Number Number Text Text Text Number Text Continent Region 26 10,2 Year of independence Population GNP 10,2 10,2 45 45 60 Capital foreign Key to City ID) Code 2