there is A table and B table in A table there 5 rows and in
b table there are 2 rows i am firing query select * from
a,b what will be the output?
Answers were Sorted based on User's Feedback
Answer / santosh pashte
It is concept of CROSS JOIN..
It will display 5 * 2 = 10 rows
Is This Answer Correct ? | 41 Yes | 4 No |
Answer / manda
It gives a cartesian product or a cross product.
Is This Answer Correct ? | 11 Yes | 1 No |
Answer / mubin ahmad
select * from a,bwill be the out put in 10 rows
Is This Answer Correct ? | 11 Yes | 2 No |
Concept of cross join
the result will be 10 bcos 5*2 = 10
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / v.g.venkatesh babu
It gives error. If you want to access the data from two tables then we must use JOINS concept... so we need to use aliasis names for tables...
* so both tables A and B must have same no. of fields with same datatypes then only we can use joins.
*Both tables must associated with forign key...
Is This Answer Correct ? | 0 Yes | 4 No |
What is a constraint? Tell me about its various levels.
wht is the difference between sqlaserver2000 and 2005
how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6
What is the best free sql database?
How do you delete duplicates in sql query using rowid?
What does over partition by mean in sql?
What is the importance of sqlcode and sqlerrm?
Is sql database free?
How do you sort in sql?
How do you get all records from 2 tables. Which join do you use?
What is an oracle stored procedure?
Can dml statements be used in pl/sql?