Choosing a higher date if two date fields are present
Ok this is probably easy but I do not know the SQL syntax.
SELECT ENTERED, REENTERED FROM MYTABLE
Let us say this is our table, and both are date fields. The left field (ENTERED) is always present, but when (REENTERED) is present I want the date to be used if it is newer and I am pretty sure it will always be newer. I only need one field returned though, not both.