Multiplying fields from different tables

Craig S. Mullins, Mullins Consulting

Published: 04 Oct 2002

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

How about this?

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

You want to multiply TechRate by TechIndividualHourlyRate when PROJECT.Tech equals USER.Tech, correct? Or did I miss something?

Risk assessment procedure: How to keep it simple

Budget welcomed by tech SMBs

How to write a sales proposal for IT services

How to properly estimate a Java project

Please create a username to comment.

Tellius introduces SaaS version of its analytics platform

State of the self-service analytics market

Information Builders rebranded IBI, updates analytics suite

Amazon healthcare initiatives wake up an industry slow to change

What Amazon's culture and practices can teach your company

Break down the components of Amazon's retail business

Microsoft products address digital workplace security

Why version control is necessary in digital asset management

How to use social networking CMS to create social media sites

Oracle Autonomous Database shifts IT focus to strategic planning

Oracle Autonomous Database features free DBAs from routine tasks

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

SAP Business One ERP helps SMBs shift with changing markets

SAP Cloud Platform apps deal with pandemic problems

7 SAP S/4HANA implementation issues to address

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

Dig Deeper on IBM DB2 management

Risk assessment procedure: How to keep it simple

Budget welcomed by tech SMBs

How to write a sales proposal for IT services

How to properly estimate a Java project

Related Q&A from Craig S. Mullins

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.