SELECT ab.name, SUM(ab.totalservice) FROM ( SELECT name, SUM(totalservice) AS totalservice FROM tablea GROUP BY name UNION SELECT name, SUM(totalservice) AS totalservice FROM tableb GROUP BY name ) ab GROUP BY ab.name ORDER BY ab.name>Hi to all,
> Table A Table B > > TOTALSERVICE NAME TOTALSALES NAME > 500 A 100 A > 600 B 300 B > 700 C 400 D > >>
> TOTALSALESSERVICE NAME
> 600 A
> 900 B
> 700 C
> 400 D
>
>