TheDeveloperBlog.com

Home | Contact Us

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

SQL RIGHT JOIN

SQL right join query with sql, tutorial, examples, insert, update, delete, select, join, database, table, join

<< Back to SQL

SQL RIGHT JOIN

The SQL right join returns all the values from the rows of right table. It also includes the matched values from left table but if there is no matching in both tables, it returns NULL.

Basic syntax for right join:

SELECT table1.column1, table2.column2.....
FROM table1 
RIGHT JOIN table2
ON table1.column_field = table2.column_field;

let us take an example with 2 tables table1 is CUSTOMERS table and table2 is ORDERS table.

CUSTOMER TABLE:

IDNAMEAGESALARY
1ARYAN5156000
2AROHI2125000
3VINEET2431000
4AJEET2332000
5RAVI2342000

and this is the second table:

ORDER TABLE:

DATEO_IDCUSTOMER_IDAMOUNT
20-01-201200123000
12-02-201200222000
22-03-201200334000
11-04-201200445000

Here we will join these two tables with SQL RIGHT JOIN:

SQL> SELECT ID,NAME,AMOUNT,DATE
FROM CUSTOMER
RIGHT JOIN ORDER
ON CUSTOMER.ID = ORDER.CUSTOMER_ID;
IDNAMEAMOUNTDATE
2AROHI300020-01-2012
2AROHI200012-02-2012
3VINEET400022-03-2012
4AJEET500011-04-2012
Next TopicSQL Full 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