Interested to Buy Any Domain ? << Click Here >> for more details...
I have two tables :
COuntry,city
I want all the cities in each country.Question on Cross Join.
- 3 Answers
- 6327 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 use "out" parameter properly?
How to connect asp pages to oracle servers?
How to define Data Block size ?
How to calculate date and time differences in oracle?
what is null value?
Explain a synonym?
What is the difference between Delete, Truncate and Drop in Oracle?
Why cursor variables are easier to use than cursors?
Is the After report trigger fired if the report execution fails ?
Explain the use of owner option in exp command.
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
Explain the use of show option in imp command.
Oracle General 
