$spl8=select * from mst_cont left join mst_kyositu on mst_cont.kyousitu_kubun = mst_kyositu.kyousitu_kubun where mst_kyositu.kaijo_cd = 674;[templ] ==