[Dbix-class] union

[Octavian Rasnita]

Great! This way it works wonderfully.

Thank you.

Octavian

----- Original Message ----- 
From: "Marc Mims" <marc at questright.com>
> You can create a result source for your query:
> 
> package MySchema::Whatever;
> use base qw/DBIx::Class/;
> 
> __PACKAGE__->table('DUMMY');
> __PACKAGE__->add_columns(qw/a b c v/);
> __PACKAGE__->result_source_instance->name(\<<'');
> (select a, b, c, 'var1' as v from table1
> where d='value'
> union select a, b, c, 'var2' as v from table2
> where d='value')
> 
> 
> 1;
> 
> _________________________________