What are Joins in SQL ?

1. Full .NET Interview Course (with PDF Book)
C# / ASP.NET Core / MVC / API - Top 500 Interview Questions
www.udemy.com/...
Don't worry if course not helping you, Udemy has 30 days Free Refund Policy.
2. Quick Revision Book (PDF format)
Top 500 .NET Interview Questions - OOPS/ C#/ ASP.Net/ MVC/ SQL /.Net Core /Web API
imojo.in/inter...
50% Discount Applied on above link.
Don't worry if book not helping you, I will return 100% of your money with in 7 days of purchase. Just mail me at [e-mail].
My best wishes are with you.

[@artick134]

Thank you brother you are a really good explainer

[@interviewhappy]

You are welcome @artick134

[@NikitaKumari-zd7jk]

Select*student ID,Name,Department from table1 inner join table1 on table1.student ID=table2.studentID

[@edwardnapatalio853]

Select * from table1 t1, table2 t2 where t1.studentId=t2.studentId;

[@Najla203]

Thank you

[@rishabhghosal8076]

This is natural join right?