PROBLEMA SQL

[federico75]

Ho fatto la select sottostante e mi riporta l'errore che non so da cosa dipende.

Il campo ID_barca e di tipo numerico (intero lungo).
L'errore è avvenuto quando ho messo WHERE ID_barca = 3



SELECT DISTINCT Start_Date, End_Date FROM tEvents WHERE (Start_Date >=#01/10/2005# AND Start_Date <= #31/10/2005#) OR (End_Date >=#01/10/2005# AND End_Date <= #31/10/2005#) OR (Start_Date < #01/10/2005# AND End_Date > #31/10/2005# ) WHERE ID_barca = 3 ORDER BY Start_Date

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(Start_Date >=#01/10/2005# AND Start_Date <= #31/10/2005#) OR (End_Date >=#01/10/2005# AND End_Date <= #31/10/2005#) OR (Start_Date < #01/10/2005# AND End_Date > #31/10/2005# ) WHERE ID_barca = 3'.

/team_calendario.asp, line 185

[ivanhalen]

SELECT DISTINCT Start_Date, End_Date FROM tEvents WHERE (Start_Date >=#01/10/2005# AND Start_Date <= #31/10/2005#) OR (End_Date >=#01/10/2005# AND End_Date <= #31/10/2005#) OR (Start_Date < #01/10/2005# AND End_Date > #31/10/2005# ) AND ID_barca = 3 ORDER BY Start_Date

[federico75]

Ho messo:

SELECT DISTINCT Start_Date, End_Date, ID_barca FROM tEvents WHERE (Start_Date >=#01/10/2005# AND Start_Date <= #31/10/2005#) OR (End_Date >=#01/10/2005# AND End_Date <= #31/10/2005#) OR (Start_Date < #01/10/2005# AND End_Date > #31/10/2005# ) AND ID_barca = 3 ORDER BY Start_Date

L'errore non si presenta ma mi va vedere tutti i record.
Devo far vedere solo i valori con ID_barca specificato.


Forse va messo AND ID_barca = 3 dentro le parentesi (Start_Date >=#01/10/2005# AND Start_Date <= #31/10/2005#)


Ciao.

Federico

[ivanhalen]

ID_barca è nella tabella tEvents? suppongo di no, e in questo caso devi fare una join tra le tabelle...

SELECT DISTINCT Start_Date, End_Date, ID_barca FROM tEvents, tabella_delle_barche WHERE (Start_Date >=#01/10/2005# AND Start_Date <= #31/10/2005#) OR (End_Date >=#01/10/2005# AND End_Date <= #31/10/2005#) OR (Start_Date < #01/10/2005# AND End_Date > #31/10/2005# ) AND ID_barca = 3 AND ID_barca = foreign_key_di_tEvents ORDER BY Start_Date

Ti consiglio di studiare un po'di SQL: http://www.w3schools.com/sql/default.asp