From MySQL Command

SELECT * FROM Table_name; 

This shows all data on the table called Table_name

 SELECT address.person, city.name FROM city, address WHERE (city.zipcode = address.zipcode)

If you store a person's address in one table (we have called it address) and you store the names of the cities associated with each zip code in another table (we have called it city) then the above query will return the name of a person, and the name of their city. When using 2 tables, refer to the data fields as table.field.