Dividenden-/Rentenzahlungen |
|||||||
Titel | Ex-Datum | Anzahl | Bruttobetrag | Zahldatum | Nettobetrag | ändern | entfernen |
SELECT a.symbol,a.ex, c.Boerse,a.scurr,b.divdate,b.Dividende FROM stocks as a
INNER JOIN dividends as b on a.symbol = b.symbol
INNER JOIN exchanges as c on a.ex = c.code
WHERE a.isin= 'GB00BN7SWP63' AND a.symbol <> 'GS71.DEX' ORDER BY b.divdate DESC;