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
- 14380 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's the difference between inner join and left join?
Which operator is used in query for pattern matching?
What is clause?
How run sql*plus commands that are stored in a local file?
Where is pl sql used?
How do I create a sql script?
How can I make sql query run faster?
how to return query output in html format? : Sql dba
What is set serveroutput on?
How do I view a sql trace file?
What is nvarchar in sql?
What is field delimiter?
what is oltp (online transaction processing)? : Sql dba
what is sql? : Sql dba
What is row_number () in sql?
