How can we subtract values in MySQL table with the help of LEFT JOIN?

It can be understood with the help of an example in which two tables are having some values and we subtract the values with the help of LEFT JOIN. Here we are taking two tables having the following data −

mysql> Select * from value_curdate;
+----+----------+-------+
| Id | Product  | Price |
+----+----------+-------+
| 1  | Notebook | 100   |
| 2  | Pen      | 40    |
| 3  | Pencil   | 65    |
+----+----------+-------+
3 rows in set (0.00 sec)

mysql> Select * from value_prevdate;
+----+-----------+-------+
| Id | Product   | Price |
+----+-----------+-------+
| 1  | Notebook  | 85    |
| 2  | Pen       | 34    |
| 3  | Pencil    | 56    |
| 4  | Colors    | 65    |
| 5  | Fevistick | 25    |
+----+-----------+-------+
5 rows in set (0.00 sec)

The above two tables are having the current price and previous price of products respectively. Now the following query, by using LEFT JOIN, will find the difference in price between the same products stored in both the tables.

mysql> Select value_curdate.id, value_curdate.product, value_curdate.price as Curprice,value_prevdate.price as 'prevprice', value_curdate.price-value_prevdate.price as 'Difference' from value_curdate LEFT JOIN value_prevdate ON value_curdate.id = value_prevdate.id ;
+----+----------+----------+-----------+------------+
| id | product  | Curprice | prevprice | Difference |
+----+----------+----------+-----------+------------+
| 1  | Notebook | 100      | 85        | 15         |
| 2  | Pen      | 40       | 34        | 6          |
| 3  | Pencil   | 65       | 56        | 9          |
+----+----------+----------+-----------+------------+
3 rows in set (0.00 sec)

Vrundesha Joshi

Published on 20-Feb-2018 11:58:13

• Related Questions & Answers
• How can we create a MySQL view with LEFT JOIN?
• How can we insert values into a table with the help of MySQL self-computed output?
• How can we write MySQL query for inner joins with the help of keyword JOIN?
• How can we write MySQL query for cross joins with the help of keyword JOIN?
• How can we convert subqueries to LEFT JOIN?
• How can we display all the records from MySQL table with the help of PHP script?
• How can we filter data with the help of MySQL subquery?
• How to remove duplicate values from a MySQL table using LEFT JOIN?
• How can we update the values in one MySQL table by using the values of another MySQL table?
• What is MySQL LEFT JOIN and how can we write MySQL query for it?
• How can we update values in a MySQL table?
• How can we add values into the columns of a MySQL table?
• How can we update MySQL table after padding a string with the values of the column?
• How can we create a MySQL view with INNER JOIN?
• How can we create a MySQL view with RIGHT JOIN?