Tag: SQL Joins

Oct 14

SQL Joins – Self Join

Self Join – It is similar type of Inner Join but it joined with self (same) table. Particularly when the table has a FOREIGN KEY that references its own PRIMARY KEY. Let’s take an example of Employee Table where ReportTo used to make join on same table. Kindly refer SQL Joins post for table schema.    …

Continue reading »

Oct 14

SQL Joins – Inner Join

Inner Join selects the exactly matching records from two or more than two tables. Lets take an example of Department and Employee Table discussed in SQL Joins post Department Table                                                 Id Name …

Continue reading »

Oct 09

SQL Joins

SQL Join clause used to combines multiple columns from two or more tables in a relational database. Join condition is part of sql query that used to retrieve data from two or more tables. Condition is used to select, update or delete the records. There are six types of joins present in sql i.e. INNER …

Continue reading »