17,086
社区成员
发帖
与我相关
我的任务
分享
select *
from P_PUBLIC_POLICY left join P_FREIGHT_SPEC F
on P_PUBLIC_POLICY.APPLYNO = F.APPLYNO
AND P_PUBLIC_POLICY.UNITCODE = F.UNITCODE
AND P_PUBLIC_POLICY.APPLYNO = F.APPLYNO
AND P_PUBLIC_POLICY.APPLYENDORSENO = F.APPLYENDORSENO
AND F.NUMBERPLATE='车牌'
WHERE
3 > 2
AND P_PUBLIC_POLICY.APPLYNO = 'AHANHNE44207P000001X'
and p_public_policy.unitcode='3010100'
select *
from P_PUBLIC_POLICY left join P_FREIGHT_SPEC F
on P_PUBLIC_POLICY.APPLYNO = F.APPLYNO
AND P_PUBLIC_POLICY.UNITCODE = F.UNITCODE
AND P_PUBLIC_POLICY.APPLYNO = F.APPLYNO
AND P_PUBLIC_POLICY.APPLYENDORSENO = F.APPLYENDORSENO
AND F.NUMBERPLATE='车牌' -- 这一句是连接条件还是检索条件,你考虑清楚
where -- 与P_FREIGHT_SPEC F无关的条件别写在连接条件里
3 > 2 -- 你这有什么用
AND P_PUBLIC_POLICY.APPLYNO = 'AHANHNE44207P000001X'
and p_public_policy.unitcode='3010100'
通过关联字段,采用外连接方式可以实现的,看看你是不是连接没写对
--把你的表结构和相应的需求都说清楚!
select a.*,b.* from
(select * from P_PUBLIC_POLICY WHERE APPLYNO = 'AHANHNE44207P000001X' and unitcode='3010100') a
left join
(select * from P_FREIGHT_SPEC where NUMBERPLATE='车牌')b
ON a.APPLYNO = b.APPLYNO
AND a.UNITCODE = b.UNITCODE
AND a.APPLYNO = b.APPLYNO
AND a.APPLYENDORSENO = b.APPLYENDORSENO
;