mysql 左连接主表信息重复问题

SELECT * FROM table1 as a
LEFT join table2
as b ON a.`name_t`=b.name_t

WHERE a.id=1

posted @ 2019-08-30 23:42  Angry-rookie  阅读(852)  评论(0)    收藏  举报