Combine Two Tables, for this simple mysql case, is there any fast solution? -

is there faster solution case? thinks 21.89% fast enough.

select firstname, lastname, city, state person left join address on person.personid = address.personid; 

table: person

+-------------+---------+ | column name | type | +-------------+---------+ | personid | int | | firstname | varchar | | lastname | varchar | +-------------+---------+ personid primary key column table. table: address

+-------------+---------+ | column name | type | +-------------+---------+ | addressid | int | | personid | int | | city | varchar | | state | varchar | +-------------+---------+ addressid primary key column table.

write sql query report provides following information each person in person table, regardless if there address each of people:

firstname, lastname, city, state