correct syntax??

[bolonga]

Hi there,
From the 2 tables, I select all the items based on the "location of 2006-12-18 00:00:00"

"select T1.P_ID, T1.Date, T1.SN, T1.Batch, T1.Result, T2.D2, T2.D4, T2.D6, T2.D8, T2.D1, T2.D3, T2.D5, T2.D7, T2.TP_Batt, T2.ROC, T2.VAUX1
from tester AS T1, others_test As T2 where 2006-12-18 24:00:00 > T1.Date > 2006-12-18 00:00:00"

Is this the correct syntax? If not, plz let me not?
Regards, -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Beau]

SELECT t1.P_ID, t1.Date, t1.SN, t1.Batch, t1.Result, t2.D2, t2.D4, t2.D6, t2.D8,
t2.D1, t2.D3, t2.D5, t2.D7, t2.TP_Batt, t2.ROC, t2.VAUX1
FROM tester AS t1
JOIN others_test AS t2
WHERE t1.Date BETWEEN 2006-12-18 24:00:00 AND 2006-12-18

00:00:00

Also, you have no join condition for others_test so you will get all rows of this table joined to each row of tester. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --