How To Differentiate Between Equi Join And Natural Join In SQL? Briefly Explain With An Example.


2 Answers

Saadia Samad Profile
Saadia Samad answered
For Equi join
Columns need to specify onto which you want to put equi join
For Example
SQL> select dpt.dptno from dept join emp on emp.dptno=dpt.dptno;

For natural you need not to specify column names for the join – it will automatically join same name columns in two different tables
For Example
Natural Join:SQL> select dptno from dept natural join emp;
Kasenene Brian Profile
Kasenene Brian answered

Mention and describe any two promising interaction technologies that will affect ubiquitous computing environments

Answer Question