急!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
...全文
78 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
yesyesyes 2005-05-17
  • 打赏
  • 举报
回复
大概是from子句太复杂了吧
senol 2005-05-17
  • 打赏
  • 举报
回复
up
senol 2005-04-26
  • 打赏
  • 举报
回复
还没有正确的答案
楼上的答案和我的比较就是省略了outer。而实际上left/right outer join是可以简写为left/right join的
cb0912cn 2005-04-15
  • 打赏
  • 举报
回复
You can create three types of outer joins to specify which unmatched rows to include in the querthe leftmost table or query in the JOIN clause are included. Unmatched rows in the rightmost table or query in the JOIN clause do not appear.

Access database SQL example


SELECT Customers.CompanyName, Customers.ContactName, Orders.OrderID, Orders.OrderDate
FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

Access project SQL example

SELECT dbo.Customers.CompanyName, dbo.Orders.OrderID, dbo.Orders.OrderDate
FROM dbo.Customers LEFT OUTER JOIN
dbo.Orders ON dbo.Customers.CustomerID = dbo.Orders.CustomerID

y results: left outer join, right outer join, or full outer join.
Left outer join All rows from
cb0912cn 2005-04-15
  • 打赏
  • 举报
回复
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 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
饮水需思源 2005-04-15
  • 打赏
  • 举报
回复
'这样试试:
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 , t_activitycategory , t_activity , t_member ,t_orderform
where t_member.member_id=t_activity.person_incharge and
t_activitycategory.category_id=t_activity.category_id and
t_subactivity.activity_id=t_activity.activity_id and t_orderform.o_f_number=t_subactivity.o_f_number AND t_orderform.o_f_number=2004090201
senol 2005-04-15
  • 打赏
  • 举报
回复
报错:Join expression not supported.

7,713

社区成员

发帖
与我相关
我的任务
社区描述
Microsoft Office Access是由微软发布的关系数据库管理系统。它结合了 MicrosoftJet Database Engine 和 图形用户界面两项特点。
社区管理员
  • Access
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧