MAX(column1,column2)

[Gavriel Fleischer]

Hi!

I need to do something like this:

CREATE table a (
id INT,
name VARCHAR(32),
last TIMESTAMP
);

CREATE table b (
id INT,
salary INT,
last TIMESTAMP
)

SELECT a.id, a.name, b.salary, MAX(a.last,b.last) AS last FROM a LEFT JOIN b ON a.id=b.id;

As you see I have different data about the same person in the two tables, but the two tables are updated in different time, and I need to know when was the last modification for a certain person (wheter it was in a or b)

(In my real problem I have actually more tables in a more complex join)

Is there any way to do this MAX(col1,col2,col3) thing?