I have two tables :
COuntry,city
I want all the cities in each country.Question on Cross Join.
- 3 Answers
- 5746 Views
- Microsoft, I also Faced
- E-Mail Answers
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 |
How to resolve the ORA-39133 error in Oracle?
How to use "in" parameter properly?
How to handle a single quote in oracle sql?
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
What is a parameter file in oracle?
How to return top 5 rows in oracle?
Difference between NO DATA FOUND and %NOTFOUND?
what are Triggers?
What are the parameters that we can pass through a stored procedure?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Which are the five query types available in oracle?
What is not equal to in oracle?
Oracle General 
