Say, you have two tables
name_info(id int, name string);
visit_info (id int, entry_date date, departure_date date )
The query would be:
SELECT a.id, a.name, b.id, b.entry_date, b.departure_date FROM name_info a, visit_info b WHERE a.id=b.id
SELECT a.id, a.name, b.id, b.entry_date, b.departure_date FROM name_info a JOIN visit_info b ON( a.id=b.id )
Let us know if this is not enough.