SELECT a.backup_id, a.archive_id, a.file_name, a.file_size, b.somethingFROM archive a, burp bWHERE a.aname = b.aname and a.backup_date < 'now'::datetime - '(select maxday_savefile from service) days'::timespan;
this does not work, any suggestionsjnc