sql内连接基础上,再进行条件查询

2024-12-02 13:43:07
推荐回答(1个)
回答1:

SELECT a.*,b.*
FROM table_a a
INNER JOIN table_b b
ON a.id=b.id
where left(b.serNum,3)>203