SELECT COUNTRY.COUNTRY_NAME,CITY.CITY_NAME FROM COUNTRY,CITY WHERE COUNT

I have two tables :
COuntry,city
I want all the cities in each country.Question on Cross Join.

Question Posted / saiki

Answer Posted / saiki

SELECT COUNTRY.COUNTRY_NAME,CITY.CITY_NAME
FROM COUNTRY,CITY
WHERE COUNTRY.COUNTRY_NAME = CITY.COUNTRY_NAME
GROUP BY COUNTRY.COUNTRY_NAME;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2246

candidate key is subset of super key but not vice-verse explain

2056

What is sequence?

1054

What is ordinary table in oracle?

1131

What are the limitations oracle database 10g xe?

1020

How can I introduce multiple conditions in like operator?

968

How to check database size in Oracle?

1168

Explain oracle 12c new features for developers?

1023

What is dual table oracle?

964

What is recovery manager(rman) backup in Oracle?

1171

What is memory advisor in Oracle?

1058

Explain table?

1097

What is using clause and give example?

1014

How to create a single index for multiple columns?

1007

What are the data types in oracle?

1018