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

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

Question Posted / u.radha

Answer Posted / u.radha

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

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the different types of database objects?

1114

How to get a list of all background sessions in the database?

1038

How to connect to a remote server?

1187

How to invoke the original export import utilities?

1132

How to use an explicit cursor without open statements?

1100

How to turn on or off recycle bin for the session?

1174

What is a user role in oracle?

1183

What is an oracle tablespace?

1094

What is an Oracle index?

1699

what is the difference between substr and instr function in oracle?

1142

How to start instance with a minimal initialization parameter file?

1084

What is Java Pool in Oracle?

1237

How to create a table index?

1227

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

1263

what is the dual table in oracle?

1038