Brilliant! That is indeed the answer I was (blindly) looking for.
Thanks greatly.
Iain.
On 10 April 2013 20:46, Matthew Phillips wrote:
> Hi Lain,
> What you are looking for is the coderef syntax for declaring a
> relationship as describe here:
> https://metacpan.org/module/DBIx::Class::Relat
Hi Lain,
What you are looking for is the coderef syntax for declaring a relationship
as describe here:
https://metacpan.org/module/DBIx::Class::Relationship::Base#condition
Cheers,
Matt
On Wed, Apr 10, 2013 at 3:40 PM, Iain C Docherty <
dbix-cl...@iain-docherty.com> wrote:
> I have googled for
I have googled for this, as far as I can tell DBIx::Class does not support
complex joins. An example of which is below.
select star.id,star.name,body.id,body.name,building.class,empire.name
from star
LEFT JOIN probes
ON star.id = probes.star_id
AND probes.alliance_id=26
LEFT JOIN body
ON sta