Creating sub selects with the

rbuser

Hi,

Reportbuilder Enterprise 6.03


we need to create a query like the one below using the
Query designer (and this is only a simple one)

SELECT achternaam AS Expr1, resourceid AS Expr2
FROM resources
WHERE (resourceid NOT IN
(SELECT resources.resourceid
FROM resources
INNER JOIN geplaatst ON resources.resourceid = geplaatst.resourceid
INNER JOIN opdrachten ON geplaatst.opdrachtid = opdrachten.opdrachtid
WHERE
(opdrachten.einddatum IS NULL) OR
(opdrachten.einddatum >= { fn CURDATE() })))


Is there an easier way than to manually add the complete subselect
in a single search clause. ??

Are there any replacements for the current Query designer. It works fine
but complex SQL statements are hard to define
- Subselects
- Union etc

regards
Paul Sjoerdsma

digitalmetaphors

There really isn't an easier way to enter a query like that. There aren't
any replacements for the query designer that anyone else has developed which
we know of either.

--
Cheers,

Alexander Kramnik
Digital Metaphors