PDA

View Full Version : Picking up fields from various tables.



kettle_anonymous
04-05-2006, 06:07 PM
I am working on a test project and I need to pick up fields from different tables.

SALES TABLE
Products -- Units sold
Product A -- 300
Product B -- 500
Product C -- 400
Product D -- 300

RETURNED UNITS TABLE
Products -- Units returned
Product A -- 30
Product B -- 50
Product C -- 40
Product D -- 30

I need to produce a table that looks like

Products -- Units sold -- Units returned
Product A -- 300 -- 30
Product B -- 400 -- 40
Product C -- 500 -- 50
Product D -- 300 -- 30

Something like this so that I can push the values into a calculator. Will this be possible?

kettle_anonymous
04-05-2006, 06:16 PM
Actually, I have 6 tables and I have to pick 1 field on each tables. If it is only one field, then I can do it with a look up table. But with this problem, is there anything more efficient?

Thanks!