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

23 votes207 views6 answers
Create table sql
SQL
6 votes164 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote186 views1 answer
Query for backup a database at another location in file system
SQL
10 votes181 views2 answers
Rtrim sql
SQL
0 vote169 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote177 views1 answer
Sql bild in function
SQL
0 vote161 views1 answer
Sqldf change user
SQL
12 votes156 views2 answers
Delete all data in neo4j
SQL
10 votes158 views4 answers
Join with multiple conditions sql
SQL
0 vote176 views1 answer
Netstat -tln mysql
SQL