Skip to main content

Posts

Showing posts with the label Sql server inner join

What is SELF JOIN and when would you use it?

What  is SELF JOIN and when would you use it? A SELF JOIN is join which is used to join a table to itself. There is no SELF JOIN keyword and it is used to compare values in a column with other values in the same column in the same table. For Example, SELECT * FROM TableA t1 , TableA t2 WHERE t1 . Id = t2 . Id In the above query, WHERE clause could be any given expression as per you! I hope you are enjoying with this post! Please share with you friends!! Thank you!!!
Read more

What is inner join in SQL? Why you use?

What is inner join in SQL? Why you use? Inner Join returns the matched rows from both the tables. If both the keys are matched then return rows otherwise not! I hope you are enjoying with this post! Please share with you friends!! Thank you!!!
Read more