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.

Reply via email to