I have two tables :
COuntry,city
I want all the cities in each country.Question on Cross Join.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / 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 |
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
How to create a testing table in oracle?
How many file formats are supported to export data?
What happens if you use a wrong connect identifier?
What do you mean by merge in oracle and how can we merge two tables?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
find out first highest salary?
10 Answers Verinon Technology Solutions,
Why is oracle used?
How to end the current transaction in oracle?
what is the scripts in data base?
What is an oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?