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
- 14135 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 column? : Sql dba
Do ddl statements need commit?
Can we create index on primary key?
How do I run a sql trace?
what is union, minus and interact commands? : Sql dba
Can we use ddl statements in stored procedure?
How do you create a db file?
How does left join work in sql?
How does an execution block start and end in pl sql?
What is the difference between inner join and left join?
What is the execution plan in sql?
explain the delete statements in sql
How do you identify a primary key?
How to select random rows from a table?
What is trigger price?
