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 is data block in Oracle?

1116

Difference between varchar and varchar2 data types?

1185

What is the data type of dual table?

995

Differentiate between post-database commit and post-form commit?

1048

How to use an explicit cursor without open statements?

1055

State any two functions of oracle?

1046

How to drop a tablespace?

1044

State the various uses of dbcc command?

1060

What are the different types of record groups in oracle? Explain each of them

1026

How to build data dictionary view an new database?

1010

What is the maximum number of triggers that can be applied to a single table?

1027

What is a oracle database?

1056

How to use "while" statements in oracle?

1327

What are the various types of snapshots ?

1029

How to find out what oracle odbc drivers are installed?

1042