Re: SQL question

Tom,

This is the answer! Thanks to you and everyone that has replied! Have a great week -
Leanne
~~Have you tried a synchronized sub-query? Try something like:
~~
~~ select a.name, a.value1, a.value2, a.systime
~~ from table a
~~ where a.systime = (select max(b.systime)
~~ from table b
~~ where b.name = a.name);
Received on Mon Jan 15 1996 - 08:31:45 CST