How many joining conditions are required to join 4 tables in SQL?
A) 1 B) 2
C) 3 D) 4
How many join conditions are required to join on tables
Answer: C) 3
Explanation:
To join ‘n’ tables ‘n-1’ conditions should be satisfied.
So to join 4 tables 3 conditions should be satisfied.
Subject: Oracle Certification
Job Role: Analyst , Database Administration , IT Trainer