不懂编程，谁帮我下把这个*= 改成 left join这样的，就是2000的改成2008下的语句
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
