select sg.group_name gname , sg.* ,si.*
from sys_group sg
left join sys_item si
on sg.item_id = si.item_id
where sg.group_name like '%2%'
and sg.is_del = 1
and sg.Item_id = 49
SQL语句---别名
最新推荐文章于 2022-12-23 12:16:43 发布