select first_names || ' ' || last_name as name from cc_users where user_id=:user_id select first_names, last_name from cc_users where user_id=:user_id select attn, line1, line2, city, usps_abbrev, zip_code, phone, country_code, full_state_name, phone_time from ec_addresses where address_id=:address_id