SELECT     a.*, b.FileName, 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, 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      *= b.autoinc AND a.CurrencyID *= c.autoinc AND a.supplierid *= d .autoinc AND a.MakerID = f.autoinc

SELECT  a.*, b.FileName, 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, AS CurrencyCnName, d .EnName AS SupplierEnName, d .Address AS SupplierEnAddress, f.Realname
FROM  EXP_PurContract_Fabric a left join BAS_TitleInfoManager b on = b.autoinc AND left join BAS_Currency c on a.CurrencyID = c.autoinc AND left join  bas_supplier d on a.supplierid = d .autoinc inner join sys_user f on a.MakerID = f.autoinc