> > try select * from payment as p, (select * from datelist('8/1/2005, > > 8/5/2005')) as date> > where date...... = p.....> > > The problem is the function's parameters '8/1/2005', '8/5/2005' has to refer to whatever value on the payment records.