what about equi join, non equi join, natural join, cross join? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

what about equi join, non equi join, natural join, cross join?

14th Aug 2016, 6:52 AM
AKSHAY MALVIYA
AKSHAY MALVIYA - avatar
5 Answers
0
when ever we need access data from more than one table then we use JOINS EQUI join- suppose I have employee and department table those contain depatment_id of employees... when we join both the table its match department_id from both table and result will display..
14th Aug 2016, 7:29 AM
Dipak Wani
0
non-equi join- is same as vice versa
14th Aug 2016, 7:30 AM
Dipak Wani
0
equi join is also known as natural join and simple join
14th Aug 2016, 7:31 AM
Dipak Wani
0
you can speak english ?
14th Aug 2016, 7:33 AM
Bagus Ari
Bagus Ari - avatar
0
yes...I think u dont understand my english..first learn english and then learn Sql
14th Aug 2016, 7:52 AM
Dipak Wani