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 --