Hi,
I'm trying to select records whose caseId are *not* present in another
table.
I did a `minus` thingy on the caseIds but then the restrict clause
causes a run-time
"No match in record selector"
and that spoils the fun.
How *can* I select records that are not present in another table?
Günther
Justin, haskelldb-users, is that currently just you and me?
nonProcs = do
r <- table casesWithRGs
p <- table procedureCnts
n <- (project (caseId << r!caseId)) `minus` (project (caseId << p!caseId))
l <- table leistungIndices
restrict (n!caseId .==. l!caseId)
project (caseId << l!caseId
# dummyDouble << _sum (l!opLstgIdx))
|
