SQL - outer join - ACE workbook

Question

An outer join can be done between:

a. only two tables

b. only three tables

c. any number of tables

Comments

i think any number of table its operation  sequence like as natural join

---

@atulcse

c. any number of tables ..

 

1. https://gateoverflow.in/192299/Full-outer-join 

 

2. https://gateoverflow.in/228115/Ugc-net-july-2018-61

 

 

---

with anynumber of table

because of it need minimum two table to perform outer join or inner join.

Answer 1

Right option is (C)

An outer join can be perfomed on any number of columns. An outer join allows you to retrieve data from multiple tables, including unmatched rows from one or more tables. This can be done with any number of tables, not limited to just two or three.

 

For more details you can check below links:

https://iqratechnology.com/academy/sql-training/sql-full-join/