Consulta 2 tablas mysql con php

[maxbrauer]

Asi te arroja el resultado que quieres.



select s.id, s.modelo, s.color , (s.stock-v.total) as total

from (select sum(cantidad) as total, id_tbl_stock as id from tbl_ventas group by

id_tbl_stock) as v, tbl_stock as s where v.id=s.id


Saludos.