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 Aissam,

concatenate will do the job.

Hope it´s the right way so you get the requested results.

Rainer

[#3]

yes Rainer

Here is the attached sample.

-Raghu

[#4]

Thanks guys,

It works. I will have a good night sleep :-).

Regards,

Aissam