update groups set group_name = :group_name where group_id = :group_id update parties set email = :email, url = :url where party_id = :group_id select g.group_name, p.url, p.email from groups g, parties p where g.group_id = :id and p.party_id = :id