Problem solve
Get help with specific problems with your technologies, process and projects.
Multiplying fields from different tables
I am trying to multiply two single fields from two different tables and put that answer into a new field in a table. I am trying to estimate the individual Project Costs by taking the Techs rate in the Users table and multiplying it by the Techs individual hourly rate. Each tech has a different hourly rate. The cost will then be displayed for that particular Project Name. Every Project Name has one technician and it is not allowed to have multiple names of Projects. I've been looking online for a week now, and in books, and there seems to be no answer. Help!
Well, let's see if I have it right and can help out. The way I read your questions the two tables would look something...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Step 2 of 2:
like this:
USER ----- Tech TechRate PROJECT -------- ProjName Tech TechIndividualHourlyRate
How about this?
SELECT P.ProjName, U.TechRate * P.TechIndividualHourlyRate
FROM USER U,
PROJECT P
This was last published in October 2002
Dig Deeper on IBM DB2 management
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Data Management/Data Warehousing experts
View all Data Management/Data Warehousing questions and answers
Start the conversation
0 comments