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
- 14214 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
Can we enter data in a table in design view?
difference between anonymous blocks and sub-programs.
What is the difference between the conventional and direct path loader? : aql loader
What is the difference between left and left outer join?
What is the maximum size of sqlite database?
What is the best free sql database?
what are the differences between char and varchar? : Sql dba
What is a database event trigger?
how many ways we can we find the current date using mysql? : Sql dba
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is record variable?
What is sql in oracle?
Why left join is used in sql?
Explain the types of joins in sql?
What are different types of sql?
