0

I have 2 table

tbl1

INSERT INTO `tbl1` (`id_tbl1`, `name`, `weight`) VALUES
(1, 'data_1', 0.2),
(2, 'data_2', 0.3),
(3, 'data_3', 0.4),
(4, 'data_4', 0.5),
(5, 'data_5', 0.5),
(6, 'data_6', 0.9),
(7, 'data_7', 0.9),
(14, 'data_14', 0.2),
(15, 'data_15', 0.4),
(16, 'data_16', 0.6),
(17, 'data_17', 0.5),
(18, 'data_18', 0.7),
(19, 'data_19', 0.9);


tbl2

INSERT INTO `tbl2` (`id_tbl2`, `id_category`, `id_tbl1`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 1, 3),
(4, 1, 4),
(5, 1, 5),
(6, 1, 6),
(7, 1, 7),
(14, 3, 14),
(15, 3, 15),
(16, 3, 16),
(17, 3, 17),
(18, 3, 18),
(19, 3, 19);

and this my query

SELECT SUM(weight)  AS 'total'
FROM tbl2
JOIN tbl1 ON tbl2.id_tbl1 = tbl1.id_tbl1 GROUP BY id_category;

Result should be 3.7 and 3.3 but showing

3.6999999999999997
3.3000000000000003

Can somebody tell me what is wrong?

Thank you.

Jhohannes Purba
  • 576
  • 1
  • 5
  • 16

0 Answers0