Hi to all,

I have here two tables,

   Table A                    Table B
   
   TOTALSERVICE   NAME        TOTALSALES   NAME
     500          A              100       A 
     600          B              300       B  
     700          C              400       D

and wanted to produce the following output

   TOTALSALESSERVICE    NAME
        600             A
        900             B
        700             C
        400             D

Great ideas are very much welcome.

Looking forward for an answer.

Noel