select c.*,a.* from customers c inner join address_book a on a.customers_id=c.customers_id where c.customers_id=679 and c.members_status>1