Advertisements
Advertisements
Question
Consider the following tables – Bank_Account and Branch:
Table: Bank_Account
| ACode | Name | Type |
| A01 | Amrita | Savings |
| A02 | Parthodas | Current |
| A03 | Miraben | Current |
Table: Branch
| ACode | City |
| A01 | Delhi |
| A02 | Mumbai |
| A01 | Nagpur |
What will be the output of the following statement?
SELECT * FROM Bank_Account NATURAL JOIN Branch;
Short/Brief Note
Advertisements
Solution
| ACode | Name | Type | City |
| A01 | Amrita | Savings | Delhi |
| A01 | Amrita | Savings | Nagpur |
| A02 | Parthodas | Current | Mumbai |
shaalaa.com
SQL for Data Query
Is there an error in this question or solution?
