Joining two tables and getting the right data

[#1]

Hi Fellow users,

I have two tables I would like two join. Material table and Labor table. Here is an example what goes wrong.

Table Material

job	Material	Amount	Period
08w3000	paint	10.25	1
08w3000	steel	5.33	1
08w3000	steel1	3.66	1

Table Labor

job	Name	Hours	Period
08w3000	John	27	1

When I join the Material table with the Labor table I get the following result:

job	Material	Amount	Period	Name	Hours
08w3000	paint	10.25	1	John	27
08w3000	steel	5.33	1	John	27
08w3000	steel1	3.66	1	John	27

So when I a make a graph table I get the correct amount but the hours are (3*27)= 81hours.

Could someone help me with this problem, how can I create the following table

job	Material	Amount	Period	Name	Hours
08w3000	paint	10.25	1
08w3000	steel	5.33	1
08w3000	steel1	3.66	1
08w3000			1	John	27

Regards,

Aissam

[#2]

Hi,

You r right, joins work in that way as you defined.

to get your desired out put table , you should concatenate both the tables.

[Table Material] :

Load --------

-------

From Table_Material;

Concatenate

[Table Labor] :

Load --------

-------

From Table_Labor;

Hope so this will help you !

- Sridhar