SQL问题
街角嘚堕落 2013-02-19 02:02:36 SELECT p.*,s.package_type_code,s.package_type_name,N.NODE_NAME,
case when STATE='02' then ( select t.transport_code from f_Transport_Detail d
left join f_transport_order t on(d.transport_order_id=t.id)
where d.package_id= p.Id and t.state in('02','01') )
else '' end transport_code
from F_PACKAGE_STORAGE p
inner join F_PACKAGE_TYPE s on (s.id=p.package_type_id)
inner join NODE N ON (N.ID=P.NODE_ID)
这个怎么给transport_code过滤???比如transport_code=""