a database has two tables, Employee and Address. The Employee table has a foreign key from the Address table. Write me an SQL statement that shows me Employee names with their associated address information.
Here is an SQL statement that should do what you're asking for:
```
SELECT e.Name, a.Street, a.City, a.State, a.Zip
FROM Employee e
JOIN Address a ON e.AddressID = a.AddressID;
```
Here's how it works:

* `SELECT` specifies the columns we want to retrieve. In this case, we want the `Name` column from the `Employee` table, and the `Street`, `City`, `State`, and `Zip` columns from the `Address` table.
* `FROM` specifies the first table we want to retrieve data from, which is the `Employee` table.
* `JOIN` specifies the second table we want to retrieve data from, which is the `Address` table. The `ON` clause specifies the condition for joining the two tables, which is that the `AddressID` column in the `Employee` table matches the `AddressID` column in the `Address` table.

This assumes that the foreign key in the `Employee` table is named `AddressID`, and that it references the `AddressID` column in the `Address` table. If your column names are different, you'll need to adjust the SQL statement accordingly.

Also, this is an inner join, which means that only employees with a matching address will be returned. If you want to include employees who don't have an associated address, you can use a left outer join instead:
```
SELECT e.Name
SELECT EmployeeName, Address FROM Employee INNER JOIN Address ON Employee.AddressID = Address.ID;