SELECT
c1.currency AS [From], c2.currency AS [To] , cer.Exchange_Rate
FROM
currency c1 JOIN currency c2 ON c1.rec_id <> c2.rec_id
LEFT OUTER JOIN CurrencyExchangeRate cer ON c1.rec_id = cer.[from]
AND c2.rec_id = cer.[to]
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter