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 |
If a cursor is open, how can we find in a pl/sql block?
What is composite data type in pl sql?
Does db2 use sql?
What is sql and db2?
how to use myisamchk to check or repair myisam tables? : Sql dba
Why join is faster than subquery?
what are the t string functions available in tsql? : Transact sql
What is an emotional trigger?
What steps server process has to take to execute an update statement?
I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)
how to use case expression? : Sql dba
what is clause? : Sql dba