[Dbix-class] selecting records with no links-to

Dave Howorth dhoworth at mrc-lmb.cam.ac.uk
Fri Jun 14 11:31:02 GMT 2013


My brain is feeling fried and is failing to solve a simple puzzle.

Using the standard table 'artist' which has a primary key 'artistid'.

And the other table 'cd' that has a link to artists, via a foreign key
'artist'. There may be more than one CD associated with a single artistid.

I want a resultset containing all artists which have NO associated CD.

What's the appropriate way to select this resultset?



More information about the DBIx-Class mailing list