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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
