I use MySQL and PHP.
I have a column in table1 which shows the price of my product, on the second table I have the number of the product.
I use below select statement, it brings me all the information I need.
However I want to add one more column for the total price.
I want to see (price*number) as totalprice on my table?
How can I do that? Thank you
SELECT * FROM table1 t
( SELECT id,adet FROM table2 ) p
ON p.id = t.id;