SELECT *, (SELECT cena FROM rs_reality.v_rowdata WHERE `nabidkaid` = 6 AND byt.oznaceni = v_rowdata.oznaceni
)            FROM `byt`