select xmbh,xmmc,tzje,htbh, htmc,htje
from
(
select xmbh, xmmc, tzje from table1
) as a
left join
(
select xmbh,htbh,htmc from table2
) as b
on a.xmbh = b.xmbh

-
征途路漫漫，独自蹒跚。
仗剑孤行意觉寒，谁扬我帆？
倚万仞群山，喂见浩瀚。
万里层云皆吾伴，酒尽人酣……
抒无尽慨叹，不止伤感。
江水滔滔几人笑？与我何干？！