Hi, I'm working with CR 4.6, I have a kind of query like this:

Select table1.field1, table1.field2
From table1, table2, table3
where table1.id=table2.id etc....
and table1.id1 not in
(select id1
from table4
where local='4' and date(2001,05,21)=table_date)

How can I do to add this subquery in my principal query?
when I tried I had a problem with the date (the subquery works if
I leave local='4' but it doesn't work with the second ones)
Thanks a lot for your collaboration