Re: [Haskelldb-users] finding ids present in one table and not in another

[Bjorn B. <bj...@br...>]

How about the 'minus' function?

/Bjorn

On Sat, Apr 25, 2009 at 10:47, Guenther Schmidt <gue...@we...> wrote:
> Hi guys,
>
> I have this problem which I don't know how to solve:
>
> I need to do something with records in one table whose Id is *not*
> present in another table like
>
> testqry = do
>  l1 <- table leistungIndices
>  l2 <- table leistungIndices
>  p  <- table procedureCnts
>  restrict (l1!caseId .<>. p!caseId)
>  restrict (l1!caseId .==. p!caseId)
>  restrict (l1!caseId .==. l2!caseId)
>  project (caseId << l1!caseId
>           # fabId << l1!fabId
>           # opLstgIdx << l1!opLstgIdx
>           # opLstgIdxFab << _sum (l2!opLstgIdx))
>
> which blows up because of the 1st restrict.
>
> How can  I express this properly?
>
> Günther
>
>
> ------------------------------------------------------------------------------
> Crystal Reports &#45; New Free Runtime and 30 Day Trial
> Check out the new simplified licensign option that enables unlimited
> royalty&#45;free distribution of the report engine for externally facing
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
> Haskelldb-users mailing list
> Has...@li...
> https://lists.sourceforge.net/lists/listinfo/haskelldb-users
>