考虑到你的A.a字段只可能有一个前导的中文字 SELECT a FROM A, B WHERE (ORD(a)>127 AND SUBSTRING(a,2)=b) OR a=b 也可写作 select t.* from ( select if(ord(a)>127, substring(a, 2), a) as a FROM A) t, B where a=b
我是写成 select * from a,b where a.a=b.b or substring(a.a,2)=b.b 好像可以的样子
新问题 select * from a left join b on a.m!=b.m or a.sl!=sum(b.xl) group by b.m请问上句该如何写,显示两表m不相等的,和显示a数量sl不等于b销量的和
SELECT A.a FROM A, B WHERE RIGHT(A.a, 5) = B.b
不知道有没有其它函数可以过滤
SELECT A.a FROM A, B WHERE SUBSTRING(A.a FROM 2) = B.b
蓝JV255
S3250
OLD
钢T305
金T305
金T205
金JV255
金JV205
红Z909
SELECT a FROM A, B WHERE (ORD(a)>127 AND SUBSTRING(a,2)=b) OR a=b
也可写作
select t.* from ( select if(ord(a)>127, substring(a, 2), a) as a FROM A) t, B where a=b
select * from a,b where a.a=b.b or substring(a.a,2)=b.b 好像可以的样子
select * from a left join b on a.m!=b.m or a.sl!=sum(b.xl) group by b.m请问上句该如何写,显示两表m不相等的,和显示a数量sl不等于b销量的和