34,593
社区成员
发帖
与我相关
我的任务
分享
select TA.GoodID,TA.ScanCode as ScanCodID,TA.GoodName,TA.Spec,TA.Unit,TA.FactCode as FactCodID,RetailPric,MemPric,WholeSalePric,STBYPricA,STBYPricB,STBYPricC,STBYPricD,STBYPricE,LogPacks,goodtypeid as GoodType,SpeOffFlag,CXRange,MemberBeginLevel,MemberEndLevel,CXPric,CXKL,GoodPrtyID
,tb.BillNo as BillNoCX
from jcv_goodbaseinfo ta left join jcpscxinfo tb on ta.goodid=tb.goodid
where ScanCode='0101010003'
UNION
select TA.GoodID,TA.ScanCode as ScanCodID,TA.GoodName,TA.Spec,TA.Unit,TA.FactCode as FactCodID,RetailPric,MemPric,WholeSalePric,STBYPricA,STBYPricB,STBYPricC,STBYPricD,STBYPricE,LogPacks,goodtypeid as GoodType,SpeOffFlag,CXRange,MemberBeginLevel,MemberEndLevel,CXPric,CXKL,GoodPrtyID
,tb.BillNo as BillNoCX
from jcv_goodbaseinfo ta left join jcpscxinfo tb on ta.goodid=tb.goodid
WHERE goodid='0101010003'
UNION
select TA.GoodID,TA.ScanCode as ScanCodID,TA.GoodName,TA.Spec,TA.Unit,TA.FactCode as FactCodID,RetailPric,MemPric,WholeSalePric,STBYPricA,STBYPricB,STBYPricC,STBYPricD,STBYPricE,LogPacks,goodtypeid as GoodType,SpeOffFlag,CXRange,MemberBeginLevel,MemberEndLevel,CXPric,CXKL,GoodPrtyID
,tb.BillNo as BillNoCX
from jcv_goodbaseinfo ta left join jcpscxinfo tb on ta.goodid=tb.goodid
WHERE goodname like '%0101010003%'
select TA.GoodID,TA.ScanCode as ScanCodID,TA.GoodName,TA.Spec,TA.Unit,TA.FactCode as FactCodID,RetailPric,MemPric,WholeSalePric,STBYPricA,STBYPricB,STBYPricC,STBYPricD,STBYPricE,LogPacks,goodtypeid as GoodType,SpeOffFlag,CXRange,MemberBeginLevel,MemberEndLevel,CXPric,CXKL,GoodPrtyID
,tb.BillNo as BillNoCX
from jcv_goodbaseinfo ta left join jcpscxinfo tb on ta.goodid=tb.goodid
where (ScanCode='0101010003' or goodid='0101010003' or goodname like '%0101010003%')