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

Explain what are clusters?

1156

How to drop a stored function?

1182

How do I connect to oracle?

1080

How to define an anonymous procedure with variables?

1239

What happens if variable names collide with table/column names?

1264

How do I manually uninstall oracle client?

1151

How to see free space of each tablespace?

1081

Is oracle a programming language?

1037

Can we create database in oracle using command line ?

1132

What is an oracle table?

1031

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2398

How to call a stored function with parameters?

1095

How to list all indexes in your schema?

1141

How to rename a tablespace in oracle?

1126

What is MTTR advisor in Oracle?

1137