Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 13880 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is function and procedure?
Can you join a table to itself?
what is transaction? : Sql dba
State few characteristics of pl/sql?
Why we use pl sql?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
what is a view? : Sql dba
Can a view be mutating? If yes, then how?
What does bitemporal mean?
How to return multiple rows from the stored procedure?
What is number function in sql?
How to raise user-defined exception with custom sqlerrm ?
How to run sql statements with oracle sql developer?
What is the difference between rename and alias?
Can a composite key be null?
