我有3个表,他们有一个共同的字段user_id
gain_table
+--------------------------+
|user_id | gain_count |
| 1 | 3 |
| 2 | 4 |
| 3 | 1 |
+--------------------------+
consume_table
+--------------------------+
|user_id |consume_count |
| 2 | 5 |
| 5 | 4 |
| 6 | 7 |
+--------------------------+
join_table
+--------------------------+
|user_id | join_count |
| 1 | 3 |
| 2 | 1 |
| 5 | 4 |
+--------------------------+
我想得到这样的输出:
输出:
+-----------+--------------+--------------+------------+
|user_id | gain_count |consume_count | join_count |
| 1 | 3 | 0 | 3 |
| 2 | 4 | 5 | 1 |
| 3 | 1 | 0 | 0 |
| 5 | 0 | 4 | 4 |
| 6 | 0 | 7 | 0 |
+-----------+--------------+--------------+------------+
是的,我希望将这三个表合并为一个表,如果某个字段值为空,则为该字段值赋予0。
如何编写MySQL查询?