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...
USER ----- Tech TechRate PROJECT -------- ProjName Tech TechIndividualHourlyRateYou 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 POr did I miss something?
Dig Deeper on IBM DB2 management
Related Q&A from Craig S. Mullins
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
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
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.