mysql_左查询

image.png

做查询，b.ProvinceName as Brand 表示将查查到的b.ProvinceName 字段，结果用Brand 代替
select b.ProvinceName as Brand,c.CityName as Model,d.Name as Number,a.Date,a.XH,a.LZBM,a.SJBM,a.WorkGroup,
a.SjWorkGroup,FullName as CZY,a.DateTime from TB_WriteLog a left join TB_Province b on a.Brand=b.ID left join TB_City c on a.Model=c.ID
left join TB_DictData d on a.Number=d.ID
left join T_ACL_User e on a.CZY=e.ID
where a.CZY <>''

image.png