select raw.ipaddress, formatted.ipaddress from raw , formatted where raw.stat_date < '2000-02-26 02:00:24-08' AND formatted > '2000-02-26 02:00:24-08'::datetime - '24 hour'::timespan AND raw.ipaddress = formatted.ipaddress; gives this: NOTICE: unknown node tag 704 in fireRIRonSubselect() NOTICE: Node is: { IDENT "formatted" } NOTICE: unknown node tag 704 in modifyAggrefQual() NOTICE: Node is: { IDENT "formatted" } ERROR: copyObject: don't know how to copy 704 I recently had a crash, is this because my SQL is broken, or because of table corruption? I've dropped and re-created the "formatted" table (DROP/CREATE) and this still happens. Any ideas? (i'm using 6.5.3) thanks, -- -Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]] ************