نحوه کوئری کردن آخرین تغییرات

[mazoolagh]

SELECT "1" AS Field_Name , MAX(date1) AS Last_Update FROM table1 WHERE field1="1"

UNION

SELECT "2" AS Field_Name , MAX(date1) AS Last_Update FROM table1 WHERE field1="2"