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
- 14179 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 are the advantages a stored procedure? : Sql dba
What is input buffer in sql*plus?
How do I view a sql trace file?
Why select is used in sql?
Can we create view in stored procedure?
What are different sql data types?
Name some usages of database trigger?
what is collation? : Sql dba
How are sql commands classified?
How is debugging done?
Why do we need pl sql?
What do you mean by table in sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
how to convert dates to character strings? : Sql dba
What is dml with example?
