RE: [SQL] UNION in views

2000-11-18 Thread Diehl, Jeffrey
I'd actually like to see a view a union. I have a database where I've split up each day's data into a separate table. I had to do this to keep the number of records to a usable level. Now, if I want to do a query over the last several days, I have grief. I have kludged a system together which

Re: [SQL] how many rows? [was Re: fetching rows]

2000-11-18 Thread Johann Spies
On Fri, Nov 17, 2000 at 10:01:28AM +0100, Arnaud Vandyck wrote: > "Robert B. Easter" wrote: > > > > > you can't do that with a cursor, but you can use they mysql-ism called a > > > limit clause. for example, to fetch rows 26-50 from that query, you'd > > > do: > > > > > > select * from films lim