SQL multi-Table query
Select distinct (. name, B. name), COUNT (Electric Appliance sales revenue + special monthly sales revenue) as monse, COUNT (Electric Appliance sales revenue + special annual sales revenue) as year FROM a, B WHERE. id = B. id;
There are two tables:
Table
Name Electric Appliance monthly sales revenue Electric Appliance annual sales revenue
Zhang San 5000 200000
Li Si 6000 30000
Wang Wu 7000 700000
Table B
Name special month sales revenue special year sales revenue
Ma 2 3000 36000
Zhang San 2000 24000
Liu Qi 2500 30000
Wang Wu 1600 19200
I want to get everyone's total revenue: How to Write PHP? Thank you!
Total Monthly Income (Electric Appliance sales revenue + special monthly sales revenue) annual income (Electric Appliance sales revenue + special annual sales revenue)
Zhang San
Li Si
Wang Wu
Ma 'er
Liu Qi
Select name, sum (Electric Appliance sales revenue) as total monthly income, sum (Electric Appliance sales revenue) as annual income from (SELECT * from a table union SELECT * from B Table
) C group by name;