Re: How to join function with a table?

[Pascual De Ruvo <deruvo@xxxxxxxxx>]

On 8/5/05, Yudie Pg <yudiepg@xxxxxxxxx> wrote:

 

I thought simple join like this would work, but it doesn't

select * from payment P, datelist(P.date_start , P.date_end)

 

 try select * from payment as p, (select * from datelist('8/1/2005, 8/5/2005')) as date
where date......  =  p.....