Diferencia Entre Tablas (compra - Venta)

[fatherjuan]

while($row = mysql_fetch_array($result))
{
$ticker_compras = $row['ticker'] ;
$total_compras = $row['cant_acciones'];
$query2 = "SELECT ticker, Sum(cant_acciones) AS cant_acciones FROM ventas_acciones where
user_name = 'pitsolana' and ticker = '$ticker_compras' GROUP BY ticker" ;


$result2 = mysql_query($query2, $db);
$row2 = mysql_fetch_array($result2);

echo ($total_compras - $row2['cant_acciones']) . "|" . $ticker_compras . "<br>";

}