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