Re: difficult sql statement

I got it!!!!!!!!!

SELECT s.personalNr PersonalNr, a.test, CASE WHEN b.person IS NULL THEN 'false' ELSE 'true' END 'Signed Up'
FROM person s JOIN signedUpTest a LEFT JOIN test b ON s.personalNr = b.person AND a.test = b.test order by s.personalNr, b.person DESC;

( Actually, it's even more complicated - one more join, but that was irrelevant)...

Marcus Received on Wed Dec 29 2004 - 09:58:14 CST