SELECT DISTINCT [Atable].???,[Atable].???,[Atable].???,[Btable].???,[Btable].???,[Btable].??? FROM [Atable] ,[Btable] WHERE [Atable].[企业名称] = [Btable].[企业名称]注:???表示你需要的字段,相同的只取[Atable].???或[Btable].???
select A.字段...B.字段... from tablename1 A left outer join tabkebame2 B on A.f_关键字=B.f_外关键字
WHERE [Atable].[企业名称] = [Btable].[企业名称]注:???表示你需要的字段,相同的只取[Atable].???或[Btable].???