I use MySQL
I have below select statement which works perfectly fine.
However, I need to have another sql statment for the sum(Totalim)
All I want is to select the sum of the Totalim where unqid='ceb447bbebe756a77f3
how can I do that?
SELECT t.*,p.adet,t.alis*p.adet as Totalim
FROM table1 t
( SELECT * FROM test ) p
ON p.id = t.id