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

How data locks are respected in oracle?

1071

query optmization techniques and quwry analyser+projects+ppts

2421

Is insert autocommit in oracle?

1068

How does oracle handle read consistency?

1098

does the query needs a hint to access a materialized view?

1858

How to view the tablespaces in the current database?

979

How do I know if oracle client is installed on windows?

1024

What is meant by joins?

1062

How to change program global area (pga) in oracle?

1095

How do you bind variables in oracle?

981

What are the differences between char and varchar2 in oracle?

1173

How to use regular expression in pattern match conditions in oracle?

1041

Explain what are the advantages of views?

1069

Explain the use of ignore option in imp command.

1035

How to omit columns with default values in insert statement in oracle?

1047