where / between
Ich möchte zwei Abfragen in einem Ausdruck verknüpfen eine between (Datun) und einen Werteabfrage
SELECT * from eib_tele where last_time between '2010-7-6%' and '2010-7-14%' and where ga1=6145
leider gibt er mir eine Fehlermeldung:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where ga1=6145' at line 1
Was mache ich falsch
Ich würde mich freuen wenn mir jemand helfen könnte.
Danke im Vorraus
Götz
Subject
Views
Written By
Posted
where / between
15078
October 09, 2010 09:21AM
3851
October 10, 2010 04:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.