I wanted to multiply two values from two different tables.
I have a quantity filed stored in one table and a unit/rate field in another.
How can i write the sql statement based on a condition and store that multiplied result for further actions.
Nebil
5
Junior Poster
Recommended Answers
Jump to PostExactly as you have done there (providing both values are numeric data types,) just to be sure in case you get NULL values I would use the ISNULL function …
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.