Sven Miller wrote: > And unfortunately I don't know enough about MySQL to be more helpful. > Database links may be an Oracle-only thing. > > On 7/19/07, Theron Stanford <[EMAIL PROTECTED]> wrote: >> This sounds like a good idea. I guess I just don't know enough about >> databases yet to know how to do this linking. Mostly I just know >> about how to get DBI to interact with MySQL. >
http://dev.mysql.com/doc/refman/5.0/en/create-view.html create a view thus (from a quick scan on the doc) create view my_agregate_table as select * from maintable union select * from tempdatatable either or both of the selects can have where clauses that restrict the data 'viewed' -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
