Multiplying fields from different tables

Mullins Consulting

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...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

like this:

USER
-----
Tech
TechRate

PROJECT
--------
ProjName
Tech
TechIndividualHourlyRate

You want to multiply TechRate by TechIndividualHourlyRate when PROJECT.Tech equals USER.Tech, correct?

How about this?

SELECT P.ProjName, U.TechRate * P.TechIndividualHourlyRate 
FROM   USER U,
       PROJECT P

Or did I miss something?

This was last published in October 2002

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

Related Resources

Dig Deeper on IBM DB2 management

Related Q&A from Craig S. Mullins

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.