I have 2 tables City and Province
City(IDCity,CityName)
Province(ProvinceId,ProvinceName,IdCity)
I need help in Sql query that output like below
Cityname1
Province1
Province2
Province3
Cityname2
Province4
Province5
Province
please help me to write the Select SQL query
Go to the complete details ...