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= 'GB0007188757' AND a.symbol <> 'RIO1.DEX' ORDER BY b.divdate DESC;