I have a MySQL table that ... US" ORDER BY e.date Use table aliases - the "e" in this example to make it obvious what table a column is coming from. Besides making your query more readable ...