查看附件类型.sql

手机进销存系统Delphi源码,管理手机的进货还有销售方面的功能

/**********************************************
查看附件类型 
***********************************************/
--查看附件类型 
select p.fid,ltrim(rtrim(tfjcs.fna))as ffjcs,ltrim(rtrim(f.fname)) as ffjlx,
ltrim(rtrim((case 
when p.fjx is null then '万能'
when p.fjx is not null then (select ltrim(rtrim(tsjcs.fna))+ltrim(rtrim(tsjxh.fmodel)) from tsjxh,tsjcs where tsjcs.fid=tsjxh.fsjcs and  tsjxh.fid=p.fjx)
end))) as fjx

 from tpjzl p,tfjlx f,tfjcs
where f.fid=p.fpjlx and tfjcs.fid=p.fname
select * from tpjzl