select 
sup.FSUPPLIERID  as FID
,sup.FNUMBER  ��Ӧ�̱���
,sup_L.FNAME ��Ӧ��
,sup_L.FSHORTNAME ���
,supB.FFOUNDDATE ��������
,supB.FLEGALPERSON ����������
,supB.FREGISTERFUND [ע���ʽ�(��Ԫ)]
,supB.FSOCIALCRECODE ͳһ������ô���
,supB.FREGISTERADDRESS ע���ַ
,sup.FSUPPLIERID
--,*
 from 
T_BD_SUPPLIER sup --��Ӧ�����
left join T_BD_SUPPLIER_L sup_L on sup_L.FSUPPLIERID=sup.FSUPPLIERID--��Ӧ�̶����Ա�
left join t_BD_SupplierBase supB on supB.FSUPPLIERID=sup.FSUPPLIERID--��Ӧ�̻�����Ϣ��

where sup.FDOCUMENTSTATUS='C'--�����
and sup.FFORBIDSTATUS='A'--��
--and sup.FSUPPLIERID={0}