Diksha IT Training Centre

Important Queries in SQL Part1. Hi Everyone, We already Discussed about Oracle SQL and PL/SQL in my previous blogs . Today i will discuss about some important queries which is useful for you . For previous blogs you can able to see it in archive folder. Let's Start with Important Queries which is useful for you to writing SQL queries . As in my previous blogs i already discussed about Joins , co-related and sub query . So today we will write some important queries which will be useful for you  .   How do we Join 3 tables by using Inner Join ? Explanation: Suppose we have 3 tables student , student_details and student_details1 with one common id in all the three tables. We can write below query to Join 3 tables by using inner join: SELECT a.ID, a.Name, b.address FROM student AS a INNER JOIN student_details AS b ON a.ID = b.ID INNER JOIN student_details1 AS c ON b.id = c.id;   Below is the output of above query in image :     Here you can see the output by Joining