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
- 12898 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
Why triggers are used?
What is the difference between sql and t sql?
How do you change a value in sql?
Explain lock escalation? : Transact sql
What is sqlcommand?
Why do we use triggers?
what are the authentication modes in sql server? : Sql dba
What are the different types of dbms?
How can use stored procedures in sql?
What is prepared statement in sql?
What does dml mean?
What do you mean by stored procedures?
What is autocommit sql?
What can sql server reporting services do?
Write a sql query to get the third highest salary of an employee from employee_table?
