根据表字段值联查表数据

select 
	case when t1.FOWNERTYPEID = 'BD_Supplier'  then ( select t2.FNAME from T_BD_SUPPLIER_L t2 where t2.FSUPPLIERID = t1.FOWNERID and t2.FLOCALEID = 2052)
	      when t1.FOWNERTYPEID = 'BD_Customer'  then ( select t3.FNAME from T_BD_CUSTOMER_L t3 where t3.FCUSTID = t1.FOWNERID and t3.FLOCALEID = 2052)
		  when t1.FOWNERTYPEID = 'BD_OwnerOrg'  then ( select t4.FNAME from T_ORG_ORGANIZATIONS_L t4 where t4.FORGID = t1.FOWNERID and t4.FLOCALEID = 2052)
		  end as FOWNER,t1.FSEQ,t1.FOWNERID,t1.FOWNERTYPEID
from T_ENG_BOMCHILD t1
where t1.FOWNERID <> 0