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?

Dig Deeper on IBM DB2 management

Risk assessment procedure: How to keep it simple A risk assessment process is an important factor in creating a business continuity strategy. Explore how to conduct and evaluate a risk assessment plan in a straightforward manner.

Cheat Sheets and Quick Reference Guides A handy collection of thing you may need to look up frequently.

horsepower (hp) The horsepower (hp) is a unit in the foot-pound-second (fps) or English system, sometimes used to express the rate at which mechanical energy is expended.

foot (ft) The foot (symbolized ft) is the unit of displacement or length in the English foot-pound-second (fps) system.

area (A) Area (symbolized A) is a two-dimensional quantity representing amount or extent of surface.

CIO management mistakes and the cost of IT failure There are a lot more than eight ways to torpedo a CIO career, judging from the response to my piece this week, “CIO management mistakes that can harm CIO careers, cause IT failures,” a compilation ...

Related Q&A from Craig S. Mullins

SAP BW certification: Tips, advice and skepticism

Our expert suggests that the best way to pass the SAP BW exam is to have hands-on job experience. But that's not all he has to say about ... Continue Reading

Data export command: Migration from a DB2 table to a flat file

To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a ... Continue Reading

Resources on creating and supporting BLOBs in DB2

Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2. Continue Reading

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

SearchBusinessAnalytics

Sisense analytics platform update features AI, data prep tool

Augmented intelligence features and an in-warehouse data prep tool highlight Sisense's latest update, its second since acquiring ...

Operation Fistula uses data to treat childbirth injuries

Aided by an analytics stack developed by Exasol, nonprofit Operation Fistula is working to end obstetric fistula in targeted ...

Automated tools broaden the future scope of data science

Automated data science tools may make their way into the data science process, but are unlikely to ever be able to do everything ...

SearchAWS

Overcome these VMware Cloud on AWS migration challenges

Plan ahead for a VMware-to-AWS cloud migration with this breakdown on common challenges organizations face during the move to ...

New AWS cost management tool, instance tactics to cut cloud bills

AWS users like Lyft and Salesforce have figured out how to keep their cloud costs as low as possible, and a new cloud management ...

A complete guide to AWS re:Invent 2019

AWS re:Invent is one of the biggest cloud and IT events of the year. Use this AWS conference guide to get the latest news and ...

SearchContentManagement

New capabilities added to Alfresco Governance Services

The updates are intended to secure electronically stored information residing across different locations in light of recent ...

Top 5 Office 365 skills for SharePoint administrators

Microsoft SharePoint administrators need to branch out in their Office 365 skill set to support products tightly integrating with...

Box cloud content management helps simplify digital work

Box currently has three main areas of focus: integration with enterprise applications, content security and collaboration. The ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

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

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchSAP

Partners need to target SAP SMB market for cloud transition

In this Q&A, SAP executive Claus Gruenewald discusses how SAP partners are instrumental in servicing the SMB market and how they ...

S/4HANA Cloud integrates Qualtrics for continuous improvement

The latest version of SAP S/4HANA Cloud embeds Qualtrics XM capabilities that provide a way for users to give direct feedback ...

SAP Data Warehouse Cloud may democratize data analytics

SAP's new SAP Data Warehouse Cloud promises to make data analytics more accessible to the business. It's a needed addition to ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

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

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

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.