select * from penyewa a, rumahsewa b where 1 and a.noakaun = b.noakaun and nokppenyewa = '' AND rumahdisewa = ''