Re: Exclude duplicates except most recent using GROUP BY and HAVING

2007-02-16 Thread Joel Nimety
suggestions? Am I posting on the correct list to get this answered? Thanks. Joel Nimety wrote: The default host table can possibly have multiple records for a given workstation. Presumable the duplicate records are for historical purposes, but only one is actually current. I don't really care why

Exclude duplicates except most recent using GROUP BY and HAVING

2007-02-09 Thread Joel Nimety
| 000F20D0272D-453E8A1B-0365-CEED-02D6| CAL_LAPTOP | Fri Feb 09 09:46:09 EST 2007 CYB1| 00508BE171F3-4587E84F-0540-56B8-003D| CFWRKSTATION| Tue Feb 06 16:14:03 EST 2007 ... -- Joel Nimety Product Architect 203.541.3416 [EMAIL PROTECTED] http