[SOLVED] ID is ambiguous?

[smerny]

my query is:

	"SELECT ID, ID_user, action, DATE_FORMAT(CONVERT_TZ(time,'-00:00','-06:00'),'%m/%d/%Y, %l:%i %p') AS time
FROM tracklog t1
JOIN (
  	SELECT ID_user, MAX(ID) AS ID
  	FROM tracklog
  	GROUP BY ID_user) AS t2
  	ON t1.ID_user = t2.ID_user AND t1.ID = t2.ID";

 

and I get the error: Column 'ID' in field list is ambiguous

[fenway]

You need to specify a table prefix, just like for your ON condition -- use t2.ID.