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

What are the different types of synonyms?

1079

Is there an oracle sql query that aggregates multiple rows into one row?

934

How many types of cluster table in Oracle?

988

Explain index?

1207

What is an oracle function?

1079

Describe varray?

1009

Can we protect our pl/sql source code?

994

Can a formula column be obtained through a select statement ?

2267

What is system tablespace?

1045

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2293

How can we create the complete backup of data in the oracle.

2095

Explain the truncate in oracle?

915

What are the differences between primary key and unique key?

950

What is an oracle recycle bin?

935

Explain what are synonyms used for?

986