21,886
社区成员
发帖
与我相关
我的任务
分享
SELECT *,dbo.LD3_Consign.BillNo as abillno FROM dbo.LD3_Consign left Join dbo.BS1_BaseCode on dbo.LD3_Consign.TrafficType=dbo.BS1_BaseCode.BaseCode and BaseCodeType='fyfsb' left Join dbo.BS1_BaseCode on dbo.LD3_Consign.PassType=dbo.BS1_BaseCode.BaseCode and BaseCodeType='fhfsb' WHERE DocNo='$seach1'
SELECT B.*,dbo.LD3_Consing.BillNo as abillno FROM dbo.LD3_Consign A
LEFT JOIN Join dbo.BS1_BaseCode B ON A.trafficType = B.BaseCode
WHERE B.BaseCodeType='fyfsb' AND A.TrafficType = A.PassType AND DocNo='$seach1'
left Join dbo.BS1_BaseCode on dbo.LD3_Consign.TrafficType=dbo.BS1_BaseCode.BaseCode and BaseCodeType='fyfsb'
left Join dbo.BS1_BaseCode on dbo.LD3_Consign.TrafficType=dbo.BS1_BaseCode.BaseCode and BaseCodeType='fyfsb'
left Join dbo.BS1_BaseCode on dbo.LD3_Consign.PassType=dbo.BS1_BaseCode.BaseCode and BaseCodeType='fhfsb'