You say that the following is about to be deprecated as it isn't SQL-92 compliant:

SELECT * FROM employee e1, employee_dtl e2

WHERE e1.id = e2.id

Where did you get this info from? I wasn't aware that implicit joins were deprecated in SQL-92!