select A.cities,B.countries from A,B; where Table A has col cities w

I have two tables :
COuntry,city
I want all the cities in each country.Question on Cross Join.

Question Posted / cheeku

Answer Posted / cheeku

select A.cities,B.countries
from A,B;

where Table A has col cities
where Table B has col countries

Is This Answer Correct ?

3 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How translate command is different from replace?

1142

What happens if variable names collide with table/column names?

1269

What is backup in Oracle?

1079

How to create a new view in oracle?

1129

How to load data from external tables to regular tables?

1107

State all possible different index configurations a table can possibly have?

1104

What are privileges and grants?

1107

How to check your oracle database 10g xe installation?

1053

How to store pictures on to the database?

1034

What is hash cluster in oracle?

1250

Describe the types of sub query?

1058

What is a Garbage Collection? and what is full recursive Garbage collection?

2958

Explain the use of control file?

1178

please explain.. DB architecture ...

2083

What are the varoius components of physical database structure of oracle database?

1042