Question

Consider the following tables – LOAN and BORROWER:

Table: LOAN

LOAN_NO	B_NAME	AMOUNT
L-170	DELHI	3000
L-230	KANPUR	4000

Table: BORROWER

CUST_NAME	LOAN_NO
JOHN	L-171
KRISH	L-230
RAVYA	L-170

How many rows and columns will be there in the natural join of these two tables?

Answer 1

Rows: 2
Columns: 4

Explanation:

In a natural join, only the common row of the same field will be displayed; the common field is not repeated.