关于mysql两个表比对

[Garvin Li]

表一：
+------+-------+-------+
| name | brand | other |
+------+-------+-------+
| fe | 49 | fe |
| wo | 99 | 4g |
| ef | 23 | ij |
| ig | 41 | fe |
+------+-------+-------+

表二
+------+-------+
| name | brand |
+------+-------+
| wo | 99 |
| ig | 40 |
| co | 34 |
| ef | 23 |
+------+-------+


如何生成表3
+------+-------+-------+
| name | brand | other |buy|
+------+-------+-------+
| fe | 49 | fe |0 |
| wo | 99 | 4g |1 |
| ef | 23 | ij |0 |
| ig | 41 | fe |1 |
+------+-------+-------+

就是添加第四列，如果两个表的name和brand同时相等，第四列buy的值得1，不等为0。求大神指点！

[在路上_-]

试试

select a.name, a.brand, a.other, case when a.brand=b.brand then 1 else 0 end buy
from 表一 a left join 表二 b ON b.name=a.name

[Garvin Li]

引用 2 楼 xxzxwsx 的回复:

试试

select a.name, a.brand, a.other, case when a.brand=b.brand then 1 else 0 end buy
from 表一 a left join 表二 b ON b.name=a.name

多谢大神