> 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;
It is not correct. You have not defined the condition between hauptantrag & datenexport tables. Forward the table structures for assistance. regards, bhuvaneswaran ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings