select kq_user.num,kq_user.name,kq_day.day_time,kq_day.arrival_time,kq_user.deptName from kq_user ,kq_day where kq_user.num=kq_day.userid(+) and kq_day.day_time(+)='20100921'
错误信息:1064 - 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 ') and kq_day.day_time(+)='20100921'' at line 1
错误信息:1064 - 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 ') and kq_day.day_time(+)='20100921'' at line 1
那请问用mysql该怎么写,我只写出了select kq_user.num,kq_user.name,kq_day.day_time,kq_day.arrival_time,kq_user.deptName
from kq_user left join (kq_day) on kq_user.num=kq_day.userid;连接时间的写不出来
from kq_user left join (kq_day) on
(kq_user.num=kq_day.userid and kq_day.day_time='20100921' )