Query Problem (SQL Statement)

Hi all,
I want to create an SQL Statement but I need help. My table have
DateBegin, DateEnding, ScoreBegin and ScoreEnd. I want to select a
record which date between DateBegin and DateEnding and score between
ScoreBegin and ScoreEnd. I use MySQL Database. I have tried
"SELECT * FROM ScoreTable WHERE DateBegin >= AND DateEnding <=
AND ScoreBegin >= AND ScoreEnding <= "
there is no result using this statement. Can anyone help me?

Thanks in advance

Best Regards,
Christian

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Query Problem (SQL Statement)

Please provide an actual complete example, as opposed to the abstract form
below - sometimes it's the little details that can make a query fail.

-----Original Message-----
From: Christian Surya [mailto:csuryas@gmail.com]
Sent: Tuesday, December 21, 2004 9:19 PM
To: win32@lists.mysql.com
Subject: Query Problem (SQL Statement)


Hi all,
I want to create an SQL Statement but I need help. My table have
DateBegin, DateEnding, ScoreBegin and ScoreEnd. I want to select a
record which date between DateBegin and DateEnding and score between
ScoreBegin and ScoreEnd. I use MySQL Database. I have tried
"SELECT * FROM ScoreTable WHERE DateBegin >= AND DateEnding <=
AND ScoreBegin >= AND ScoreEnding <= "
there is no result using this statement. Can anyone help me?

Thanks in advance

Best Regards,
Christian

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=patrickq@nyc.rr.com



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org