SQL-Statement

Hello all,

I have the problem that I must create an Querry witch looks like:

--snip--

SELECT * FROM Hauptantrag WHERE (select datenfeldname from datenexport) > (select datum_von from datenexport) AND (select datenfeldname from datenexport) < (select datenexport.datum_bis from datenexport) limit 10;

--snap--

The statement (select datenfeldname from datenexport) means an fieldname witch is saved in the relation datenexport. In this relation is only one record saved and contains the fields datenfeldname, datum_von and datum_bis.

Can I do something like this?
Have I an syntax problem?

By executing I become 0 results.

Can someone please educate me...

Thanks a lot

Markus
--
Markus Espenhain Fon: +49 (7 11) 48 90 83 - 0
ETES - EDV-Systemhaus GbR Fax: +49 (7 11) 48 90 83 - 50
Libanonstrasse 58 A * D-70184 Stuttgart Web: http://www.etes.de