SELECT a.*, b.FileName, b.CnName AS TitleInfoManagerCompanyCnName, b.EnName AS TitleInfoManagerCompanyEnName, b.EnAddress, b.ZipCode, ('Tel.: ' + isnull(b.Tel, '') + ', Fax:
' + isnull(b.Fax, '')
+ ', ' + isnull(b.Web, '')) AS CompanyContact, c.EnName AS CurrencyName, c.CnName AS CurrencyCnName, d .EnName AS SupplierEnName, d .Address AS SupplierEnAddress, f.Realname
FROM EXP_PurContract_Fabric a, BAS_TitleInfoManager b, BAS_Currency c, bas_supplier d, sys_user f
WHERE a.companyid *= b.autoinc AND a.CurrencyID *= c.autoinc AND a.supplierid *= d .autoinc AND a.MakerID = f.autoinc
' + isnull(b.Fax, '')
+ ', ' + isnull(b.Web, '')) AS CompanyContact, c.EnName AS CurrencyName, c.CnName AS CurrencyCnName, d .EnName AS SupplierEnName, d .Address AS SupplierEnAddress, f.Realname
FROM EXP_PurContract_Fabric a, BAS_TitleInfoManager b, BAS_Currency c, bas_supplier d, sys_user f
WHERE a.companyid *= b.autoinc AND a.CurrencyID *= c.autoinc AND a.supplierid *= d .autoinc AND a.MakerID = f.autoinc
SELECT a.*, b.FileName, b.CnName AS TitleInfoManagerCompanyCnName, b.EnName AS TitleInfoManagerCompanyEnName, b.EnAddress, b.ZipCode, ('Tel.: ' + isnull(b.Tel, '') + ', Fax:
' + isnull(b.Fax, '')
+ ', ' + isnull(b.Web, '')) AS CompanyContact, c.EnName AS CurrencyName, c.CnName AS CurrencyCnName, d .EnName AS SupplierEnName, d .Address AS SupplierEnAddress, f.Realname
FROM
EXP_PurContract_Fabric a
left join
BAS_TitleInfoManager b
on a.companyid = b.autoinc
left join
BAS_Currency c
on a.CurrencyID = c.autoinc
left join
bas_supplier d
on a.supplierid = d .autoinc
left join
sys_user f
on a.MakerID = f.autoinc