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=''

  

原文地址:https://www.cnblogs.com/zhaojingwei/p/4660448.html