SQL rewriting

[René Speksnijder]

I do not know if I'm at the right address, but I have some kind of a problem. The situation is like this: I've got wamp installed (Windows Apache MySQL PHP). It seems it includes MySQL version 4.0.18. So no views or subqueries can be used. I do not know howto upgrade MySQL within Wamp so to me that's no option at this point. But then it's the matter with no usage of subqueries. And now I've got a query and I do not know how to write this one down without subqueries. I was wondering if you could help me with it. First of all let me write down the query with subqueries.

Create table temp_coll as
Select C.id, C.naam from collectie C
Where C.cdnr = 1
And (C.id not in (Select U.collid from uitlenen U
Where idat is NULL )
Or NOT EXISTS ( Select U.collid from uitlenen U
where U.collid = C.id ))

You can also leave the create table of course. As you can see that there are two tables involved namely: collectie and uitlenen, and the id in collectie may appear in the table uitlenen as collid.