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

How to write a query with an inner join in oracle?

972

Explain mutating triggers.

972

List out the difference between commit, rollback, and savepoint?

985

How to create tables for odbc connection testing?

1005

What is meant by a deadlock situation?

1046

What is the difference between truncate & delete command?

1122

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2183

How do you bind variables in oracle?

927

What is Data Dictionary Cache in Oracle?

1116

Explain the use of inctype option in exp command.

975

What are the built-in functions used for sending Parameters to forms ?

3307

Why is oracle so popular?

937

Explain an index segment?

1037

Explain constraining triggers.

1041

How to start your 10g xe server?

965