用inner join
from {合同} a inner join {生产计划} b on b.合同号 like ("%" + a.合同号 + "%")
-----------
select * f rom {表A} a inner join {表B} b on b.第一列 like ("%" + a.第一列 + "%")