SQL - Part 66 - Using Sub Queries for retrieving the records from multiple tables

In this video, I have explained and practically demonstrated using the Sub Query for retrieving the records from Multiple Tables

[realisnotfalsefalseisnotre]

I like this video entire playlist because, i learn new thing in this video without using joins, it's retrieves the data

[chintu]

Hai sir by using subqueries we can combine the city and country columns we can also use left join to both columns to combine

[neerajadhikari]

where will we get these city country dataset

[mdafzal]

can you please help me understand why are we putting dot(.) like country.country_id and city.city_id? why do we put dot(.)

[pranavdaine]

sir this statement is not running
select city, (select country from country, city where from city;