Hi all,
I have a database, that because of the size of the data, I have separated on
day's worth of data into it's own table. I have a separate table for each
of, say, 30 days. I would like to write a query that will query the last 15
days worth of tables. Can this be done?
I tried to use a view; that didn't work. I tried to use the union clause;
that didn't allow me to do group by...
Is there a better way than to have my program rewrite the sql on the fly?
Thanx, in advance,
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
jdiehl@sandia.gov