AND kako_irai_m.record_no NOT IN (SELECT record_no FROM uriage_denpyo)

こんな感じにすればいい