On 4/26/06, chris smith <dmagick@xxxxxxxxx> wrote: > Table joins can only be done against another table & field, I don't > think you can do it using an expression like this. That should all be > in the where clause. > > What do the timesheets and dummy_records tables look like? timesheets.weekending is a date dummy_records.sequence_nr is int8 Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au