what are the first name and last name of all candidates?
create table candidates (candidate_id varchar, PRIMARY KEY (candidate_id)); create table people (first_name varchar, last_name varchar, person_id varchar, PRIMARY KEY (first_name))
select t2.first_name, t2.last_name from candidates as t1 join people as t2 on t1.candidate_id = t2.person_id