Hello.
I'm having a problem with a probably very simple query.
I need to update a table
foo (x int, y int, last_seen timestamp, unique(x,y));
where the values should be taken from a larger table
bar( x int, y int, seen timestamp);
where each x,y combination occurs several times, and the value in
foo.last_seen should be the value max(seen) for each pair of x,y.
Notice! All combinations of x,y in bar are also in foo, but not the
other way around.
So how do I write a query for this?
Thanks in advance.