34,838
社区成员




select
[JoinFlag]='A',
A.CODE,
B.CODE
from
NameJp a
left join
NameJp b on 1=1 and B.HZ='三'--改为1=1..
where
A.HZ='张'
SELECT 'A' AS JoinFlag ,
A.CODE,B.CODE
FROM NameJp AS A
LEFT JOIN
(SELECT 'A' AS JoinFlag ,
HZ,CODE
FROM NameJp) AS B
On B.HZ = SUBSTRING('张三',2,1)
WHERE A.HZ = SUBSTRING('张三',1,1)
select
[JoinFlag]='A',
A.CODE,
B.CODE
from
NameJp a
left join
NameJp b on a.JoinFlag=b.JoinFlag and B.HZ='三'
where
A.HZ='张'
--语法没错,就是看不懂这句有啥用?
SELECT 'A' AS JoinFlag , A.CODE , B.CODE
FROM NameJp AS A
LEFT JOIN (SELECT 'A' AS JoinFlag , HZ , CODE FROM NameJp) AS B
On B.HZ = SUBSTRING('张三' , 2 , 1) AND A.JoinFlag = B.JoinFlag
WHERE A.HZ = SUBSTRING('张三',1,1)
SELECT 'A' AS JoinFlag,A.CODE,B.CODE
FROM NameJp AS A
LEFT JOIN
(SELECT 'A' AS JoinFlag,HZ,CODE
FROM NameJp
) AS B
On B.HZ = SUBSTRING('张三',2,1)
AND A.JoinFlag=B.JoinFlag
WHERE A.HZ = SUBSTRING('张三',1,1)
语法没有错误,只是不知道你想实现什么. SUBSTRING('张三',2,1)不就是 '三'吗,1,1同理.