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?

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

The Salesforce acquisition of Tableau complements Einstein Analytics

Given the different strengths of Salesforce's Einstein Analytics platform and Tableau, the BI tools could prove complementary now...

Domo management expansion signals strategic shift

Five months after it stated it would be pursuing strategic partnerships, Domo appears to be making a move toward implementing ...

Reveal moves Infragistics BI platform into embedded analytics

With the release of Reveal, an embedded business intelligence platform, longtime software vendor Infragistics is expanding its ...

SearchAWS

AWS Lambda alternatives for flexible cloud workloads

Experts share points of comparison for Lambda vs. the competition, and what other options AWS has for elastic computing without ...

Globe and Mail's AWS migration drives digital engagement

Canadian news outlet The Globe and Mail has broadly adopted AWS cloud services in a bid to increase reader engagement and digital...

What you need to know about Cloudera vs. AWS for big data

Enterprises in need of a big data platform must run some analytics of their own to choose a vendor. AWS' integration between ...

SearchContentManagement

Upgrades to Nintex Forms simplifies electronic form creation

The new form designer by Nintex brings user-friendly capabilities to Nintex Forms for both electronic form creation and data ...

4 tips for migrating ECM to the cloud

Outdated ECM systems use a lot of resources, and neglect can render them almost useless. By migrating to the cloud, businesses ...

8 steps to building a website taxonomy

Building a website taxonomy can help make website content better categorized and more easily searchable by users. Here are eight ...

SearchOracle

How Oracle RPA systems can automate business tasks for users

Robotic process automation software can be integrated into Oracle environments to help strengthen business operations by ...

Oracle Analytics Cloud update unifies BI products, pricing

Oracle Analytics Cloud now offers a consistent UI and all-in-one pricing for Oracle's analytics tools. But an on-premises BI ...

How to create Oracle Multitenant database user accounts

Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new...

SearchSAP

S/4HANA migration concerns lead SAP 2019 stories so far

Industry observers believe that if SAP is to remain competitive, S/4HANA migrations need to pick up, and new leadership needs to ...

How SAP C/4HANA could transform the CRM market

Find out how C/4HANA is not only changing the CX game, but also transforming the relationship with CRM by combining front-office ...

S/4HANA migration needs strong project management

Vinci Energies Group shows that an SAP S/4HANA migration is a difficult project that requires strong management, but the new ...

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.