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)
;