Q U E R Y

[Deependra B. Tandukar]

Greetings!

I am using MySQL in RedHat 6.2 with PHP 4.0. I have a question on MySQL. Suppose I 
have two tables A and B in my database:
Table A
Name               Score
a                        45
b                        20
c                        75
d                        55

Table B
Name                Score
a                        20
b                        9
c                        25

Now I need to subtract values of table B from table A and result should be
like:
Table C
Name                Score
a                        25
b                        11
c                        50
d                        55

How can I do this?

Looking forward to hearing from you.

Warm Regards,
Deependra B. Tandukar