sql两表联合查询

SELECT yt_fault_componentId FROM yt_fault_component a
  join yt_fault_assembly b  on  a.yt_fault_assembly=b.yt_fault_assemblyId
  where a.yt_code='' and b.yt_code=''