[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