select
FProduceDate
,DATEDIFF(day,  FProduceDate,GETDATE())  ������
,org.FNUMBER �����֯����
,orgl.FNAME �����֯
,s.FNUMBER �ֿ����
,sl.FName �ֿ����
,m.FNUMBER ��ϱ���
,ml.FNAME ������
,ml.FDESCRIPTION ����ͺ�
,inv.FBaseQty ���������
,un.FNAME �������λ
--,inv.*

from
T_STK_INVENTORY inv --��ʱ���

left join  T_BD_Stock s on inv.FSTOCKID=s.FSTOCKID--�ֿ�
left join  T_BD_STOCK_L sl on inv.FSTOCKID=sl.FSTOCKID

left join  T_BD_MATERIAL m on m.FMaterialID=inv.FMaterialID--���
left join  T_BD_MATERIAL_L ml on ml.FMaterialID=inv.FMaterialID and ml.FLOCALEID=2052

left join  T_ORG_ORGANIZATIONS org on org.FORGID=inv.FSTOCKORGID--��֯
left join  T_ORG_ORGANIZATIONS_L orgl on orgl.FORGID=inv.FSTOCKORGID and orgl.FLOCALEID=2052

left join T_BD_UNIT_L un on un.FUNITID=inv.FBaseUnitId and un.FLOCALEID=2052--��λ


where FProduceDate is not null  --������ڲ�Ϊ��
and inv.FBaseQty<>0--����������
and DATEDIFF(day,  FProduceDate,GETDATE()) >90 --������ڴ���90��
--and s.FNUMBER like '01.02%'