TheDeveloperBlog.com

Home | Contact Us

C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML

SQLite Outer Join

SQLite Outer Join with history, features, advantages, installation, commands, syntax, datatypes, operators, expressions, databases, table, crud operations, clauses, like, glob, limit, and clause, advance sqlite

<< Back to SQLITE

SQLite Outer Join

In SQL standard, there are three types of outer joins:

  • Left outer join
  • Right outer join
  • Full outer join.

But, SQLite supports only Left Outer Join.


SQlite Left Outer Join

The SQLite left outer join is used to fetch all rows from the left hand table specified in the ON condition and only those rows from the right table where the join condition is satisfied.

Syntax:

SELECT ... FROM table1 LEFT OUTER JOIN table2 ON conditional_expression 

Or

SELECT ... FROM table1 LEFT OUTER JOIN table2 USING ( column1 ,......

Image representation:

Sqlite Outer join 1

We have two tables "STUDENT" and "DEPARTMENT".

Sqlite Outer join 2

The "STUDENT" table is having the following data:

Sqlite Outer join 3

The "DEPARTMENT" table is having the following data:

Sqlite Outer join 4

Let's take the above two tables "STUDENT" and "DEPARTMENT" and make an inner join according to the below conditions:

Example:

SELECT EMP_ID, NAME, DEPT FROM STUDENT LEFT OUTER JOIN DEPARTMENT
ON STUDENT.ID = DEPARTMENT.EMP_ID;
Sqlite Outer join 5
Next TopicSQLite Cross Join




Related Links:


Related Links

Adjectives Ado Ai Android Angular Antonyms Apache Articles Asp Autocad Automata Aws Azure Basic Binary Bitcoin Blockchain C Cassandra Change Coa Computer Control Cpp Create Creating C-Sharp Cyber Daa Data Dbms Deletion Devops Difference Discrete Es6 Ethical Examples Features Firebase Flutter Fs Git Go Hbase History Hive Hiveql How Html Idioms Insertion Installing Ios Java Joomla Js Kafka Kali Laravel Logical Machine Matlab Matrix Mongodb Mysql One Opencv Oracle Ordering Os Pandas Php Pig Pl Postgresql Powershell Prepositions Program Python React Ruby Scala Selecting Selenium Sentence Seo Sharepoint Software Spellings Spotting Spring Sql Sqlite Sqoop Svn Swift Synonyms Talend Testng Types Uml Unity Vbnet Verbal Webdriver What Wpf