select 
org.fname ʹ����֯
,m.FNUMBER ��ϱ���
,ml.FNAME ������
,mb.FNameEn Ӣ�����
,ml.FSPECIFICATION ����ͺ�
,ml.FDESCRIPTION ���
,mb.FBARCODE  ���
,un_L.FNAME �ɹ���λ
,m.FMATERIALID as FID
,m.FMASTERID
,mpur.FDEFAULTVENDORID
 from 
 
T_BD_MATERIAL m  --��ϱ�
left join T_BD_MATERIAL_L ml on ml.FMATERIALID=m.FMATERIALID--��϶�����
left join t_BD_MaterialBase mb on mb.FMATERIALID=m.FMATERIALID--��϶�����
left join T_ORG_ORGANIZATIONS_L org on org.FORGID=m.FUseOrgId and org.FLOCALEID=2052--��֯
left join t_bd_MaterialPurchase mpur on mpur.FMATERIALID=m.FMATERIALID--�ɹ�
left join T_BD_UNIT_L un_L on un_L.FUNITID=mpur.FPURCHASEUNITID --��λ

where m.FDOCUMENTSTATUS='C'--�����
--and mpur.FDEFAULTVENDORID={0}