急!sql 文在sql server中能执行,但在access上报错,在线等!
senol 2005-04-15 01:21:54 SELECT t_activitycategory.user_code,t_activitycategory.categoryname,t_subactivity.subcategory_id,t_subactivity.internalcategory_id, t_activity.activity_type,t_activity.status_id,t_activity.activity_id,t_activity.Title,t_orderform.o_f_number, t_activity.person_incharge as [Person],t_activity.mer_number,t_activity.inputdate,t_activity.targetdate, t_activity.currency_id as currency_id, t_member.Ext as [Ext]
FROM (t_subactivity
INNER JOIN (t_activitycategory INNER JOIN (t_activity LEFT OUTER JOIN t_member ON t_member.member_id=t_activity.person_incharge)
ON t_activitycategory.category_id=t_activity.category_id)
ON t_subactivity.activity_id=t_activity.activity_id) INNER JOIN t_orderform ON t_orderform.o_f_number=t_subactivity.o_f_number AND t_orderform.o_f_number=2004090201