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

Explain table?

1097

What are oracle functions?

1006

What are operators in oracle?

1041

How to convert characters to times in oracle?

1003

What is dual table oracle?

964

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2216

How to define a cusotmer as a supplier in ORACLE R12

2209

How a tablespace is related to data files?

1088

What is the data type of dual table?

975

Is oracle an open source?

1058

What is a select query statement in oracle?

939

Can we connect to ORACLE db using Windows Authentication?

1228

What are the different types of partitions in oracle?

948

What is translate in oracle?

1078

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

2337