Leftjoin in sql

+----+----------+--------+---------------------+
| ID | NAME     | AMOUNT | DATE                |
+----+----------+--------+---------------------+
|  1 | Ramesh   |   NULL | NULL                |
|  2 | Khilan   |   1560 | 2009-11-20 00:00:00 |
|  3 | kaushik  |   3000 | 2009-10-08 00:00:00 |
|  3 | kaushik  |   1500 | 2009-10-08 00:00:00 |
|  4 | Chaitali |   2060 | 2008-05-20 00:00:00 |
|  5 | Hardik   |   NULL | NULL                |
|  6 | Komal    |   NULL | NULL                |
|  7 | Muffy    |   NULL | NULL                |
+----+----------+--------+---------------------+

Source: tutorialspoint.com

Similar codes

0 vote307 views1 answer
Basic structure of sql expression having clause
SQL
0 vote304 views1 answer
Multiple like values for single column postgres
SQL
7 votes290 views1 answer
Safe mode mysql
SQL
0 vote301 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote313 views1 answer
Sqlite version check
SQL
3 votes272 views4 answers
Show sql server database
SQL
0 vote315 views1 answer
Spark sql grows beyond 64 kb
SQL
6 votes285 views2 answers
WHERE value IS sql
SQL
0 vote304 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote253 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL