用这么多函数干什么?INSERT INTO TBTEMPINFO(FDID,FDTIME,FDTEMPID,FDINTIME,FDOUTTIME) SELECT A.FDID,A.FDTIME,'A000002343' AS FDTEMPID,B.FDINTIME,B.FDOUTTIME FROM TBBASEINFO A,TBWork B WHERE A.FDDATE >= #2002-08-01# AND A.FDDATE <= #2002-08-15# AND A.FDID = B.FDID AND A.FDTime >= dateadd("n",-29,b.fdOuttime) AND A.FDTime <= dateadd("n",29,b.fdOuttime) ORDER BY A.FDTIME DESC
A.FDTime的数据类型是什么?b.fdOuttime的数据类型是什么?
答:它们都是文本函数