I have two tables :
COuntry,city
I want all the cities in each country.Question on Cross Join.
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 |
Post New Answer View All Answers
How do you tell what your machine name is and what is its IP address?
How to use windows user to connect to the server?
What are the major difference between truncate and delete?
What is the difference between pre-select and pre-query?
Is oracle a programming language?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is a sub query and what are the different types of subqueries?
How to create a table in a specific tablespace?
What is a table index?
Which is better Oracle or MS SQL? Why?
How to define a variable of a specific record type?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Explain what are the advantages of views?
What are the attributes that are found in a cursor?
How can you merge two tables in oracle?