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?
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 are different types of tables in sql?
What is %rowtype in pl sql?
how would concatenate strings in mysql? : Sql dba
What are the uses of sysdate and user keywords?
What is the use of index in sql?
How does rowid help in running a query faster?
what are sequences
What is recursive join in sql?
What are the 3 types of behavioral triggers?
How do I create an index in word?
Why do we need sharding?
How much does sql cost?
How to connect a sql*plus session to an oracle server?
How do you modify a column in sql?
how to drop an existing table in mysql? : Sql dba