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
(selectdatenfeldname 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
thisrelation 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