Reinier Post wrote:
SELECT E.*
FROM Employee AS E
LEFT JOIN Dept AS D USING (DeptName)
WHERE D.DeptName IS NULL
Thanks, I didn't know about USING. Works fine, too:
That's good to hear.
Set::Relation is superfluous for this task actually.
I'd like to try it anyway,
but it won't install on my (Cygwin 1.7) system:
# Failed test 'use Set::Relation;'
# at t/Set_Relation_00_Compile.t line 9.
# Tried to use 'Set::Relation'.
# Error: Can't use an undefined value as a HASH reference at
# /usr/lib/perl5/site_perl/5.10/namespace/autoclean.pm
That looks more like a namespace::autoclean problem, actually. Are you using
the latest version?
Strictly speaking, you could remove all references to namespace::autoclean and
Set::Relation would still work, I believe; namespace::autoclean is more of a
housekeeping utility. There's just a line each in 3 files I believe.
Perl 5.10.0 is also known to have some significant bugs in it; I would use a
newer version anyway if you can, 5.12.2 being the best.
But try removing the "use namespace::autoclean;" from the source and see if the
problem goes away, if updating to the newest first doesn't work.
-- Darren Duncan
