SELECT ( cd.id_str || ' ' || cp.id_place || ' ' || cp.id_connect || ' ' || cd.ip_adr || ' ' || cd.owner || ' ' || cd.login_name || ' ' || cp.address ) AS record FROM BIL.CONNECT_DETAIL cd LEFT JOIN BIL.CONNECT_PLACES cp ON (cp.id_place = cd.id_place) ;