How to join previous entry to each database result row?

Hi,
I have a database table with entries looking like that

id | email | type | datetime
1 | a@b.com | x | 2007-03-24
3 | a@b.com | x | 2008-03-10
4 | x@y.com | y | 2007-04-27
8 | a@b.com | y | 2006-12-19
9 | x@y.com | y | 2006-11-05

Now I did a group by looking like this
SELECT MAX(datetime), email, type FROM table GROUP BY email, type
Additionally, I need the information about the previous entry, here
id | email | type | latest_date | previous_date
3 | a@b.com | x | 2008-03-10 | 2007-03-24
4 | x@y.com | y | 2007-04-27 | 2006-11-05
8 | a@b.com | y | 2006-12-19 | NULL

Any suggestions? Maybe with a VIEW?
A Sub-Select with the attached structure didn't work
(The multi-part identifier "t2.latest_date" could not be bound. [but t2.latest_date is select-able])
Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:

-- join previous entry
LEFT JOIN
	(SELECT
		MAX(t11.DateTime_Stamp) AS second_latest_date,
		t11.client_email, 
		t11.type
	FROM
		account_activity AS t11
	WHERE t11.DateTime_Stamp < t2.latest_date
	GROUP BY
		t11.client_email,
		t11.type) AS t12
ON t12.client_email = t3.client_email
	AND t12.type = t3.type