Changes between Version 1 and Version 2 of portfolio

Timestamp:

02/24/26 23:51:48 (3 days ago)

Author:

231020

Comment:

--

portfolio

@@ -10 +10 @@
     p.id AS portfolio_id,
     p.balance,
-    ph.stock_symbol,
+    s.symbol as stock_symbol,
     ph.quantity,
     ph.avg_price,
     s.current_price,
     (s.current_price - ph.avg_price) * ph.quantity AS profit_loss
-FROM portfolios p
-LEFT JOIN portfolio_holdings ph ON ph.portfolio_id = p.id
-LEFT JOIN stock s ON s.symbol = ph.stock_symbol
+FROM portfolio_holdings ph
+JOIN portfolios p ON ph.portfolio_id = p.id
+JOIN stock s ON s.id = ph.stock_id
 WHERE p.user_id = 1; --корисник Davor
 }}}