inner join - Translate Value to Name SQL -
i have 2 tables
instead of currency1id
, currency2id
, want show currencyshortcut
make better
in case managed join 1 of fields :
please me convert both of them values currency table
thanks !!
i think need this
select c1.currencyshortcut [currency1], c2.currencyshortcut [currency2] /*, other columns need*/ spot s join currencies c1 on s.currencyid = c1.currencyid join currencies c2 on s.currencyid = c2.currencyid
Comments
Post a Comment