Solved: SQL convert all numeric colums from one table into foreign currency using exchange rate in another table

Create Account

SQL

Questions

Followers

Top Experts

Murray Brown🇬🇧

SQL convert all numeric colums from one table into foreign currency using exchange rate in another table

I have two tables called Policies and Forex. I have used the following simple query to join the two tables but I want to create a query that converts all the numeric values in the Policies table to the foreign currency by multiplying the number in them by the exchange rate in the Forex.Exchange column. How do I create this?

SELECT Policies.*
FROM Policies
LEFT JOIN Forex
ON Policies.Currency = Forex.Currency;

Open in new window

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

SOLUTION

ste5an🇩🇪

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

ASKER CERTIFIED SOLUTION

Molnár István🇷🇴

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

Murray Brown🇬🇧

ASKER

Hi Ste5an. I have that already have that.

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

SQL

Questions

Followers

Top Experts

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.