I've got two tables. One ID's has and id the other, names, has id plus first_name and last_name. Names has five rows all of which match on id. When i do something like:
select ID.id, names.first, names.last from ID, name where ID.id=names.id;
I want only a single match to be returned, not five rows.