Re: Aggregating multiple databases

[prev] [thread] [next] [Date index for 2004/11/09]

Bowen Dwelle wrote:
> Simon Cozens wrote:
> 

>>
>>I'm guessing I may well have to write Songbee::Song to inherit from an
>>aggregator class that collects data from multiple Song classes generated on
>>the fly with Class::DBI::Loader, but that's as far as I can get. Can anyone
>>think of how this might be achieved?
> 
> 
> Couldn't you use Class::DBI::View and a SQL UNION?
> 
>    __PACKAGE__->setup_view(<<SQL);
>      SELECT id, title, etc
>      FROM songs_english
>      UNION
>      SELECT id, title, etc
>      FROM songs_japanese
>      etc...
>    SQL
> 

forgive the basic SQL question, but what happens to the result set when an id in 
songs_english == an id in songs_japanese?


        -- 
        Terrence Brannon, terry@xxxxx.xxx