Re: [SQL] Restricting a VIEW.

2002-10-20 Thread Ludwig Lim
--- Terry Yapt <[EMAIL PROTECTED]> wrote: > Hello all, > > I have a doubt. In the next example, I have a table > with two columns: > - DATE > - MONEY > > And a VIEW which SUM's the money GROUPing by > 'month/year' (I cut off the day)... > > Ok.. I would like to be able to SELECT * FROM VIEW..

[SQL] Restricting a VIEW.

2002-10-19 Thread Terry Yapt
Hello all, I have a doubt. In the next example, I have a table with two columns: - DATE - MONEY And a VIEW which SUM's the money GROUPing by 'month/year' (I cut off the day)... Ok.. I would like to be able to SELECT * FROM VIEW.. but restricting by complete dates (dd/mm/)... (Last select i