如何在一个MySQL查询中从两个不同的表中选择记录?

I have first names stored in one table and last names stored in another. I know this is silly but I am trying out different things as I'm just starting with MySQL. Anyway is it possible to select the first name from one table and the last name from another in one query? And put the result inside a PHP variable?I have first names stored in one table and last