数据库标签不支持多表查询吗?
我做了一个多表查询,能制作成功的,也能保存,但是再打开的时候就是报错的。是不是数据库标签不能做多表查询标签。
如果不能,能不能在模板里直接写数据库查询?请官方指点一下。
以下是我的语句:
SELECT TOP (100) PERCENT dbo.KS_FormRecord47.item0 AS Expr4, dbo.KS_FormRecord47.item1 AS Expr5, dbo.KS_FormRecord43.RecordID, dbo.KS_FormRecord43.AddDate,
dbo.KS_FormRecord43.item6, dbo.KS_FormRecord43.item0, dbo.KS_FormRecord43.item9, dbo.KS_FormRecord43.item5, dbo.KS_FormRecord43.item7, dbo.KS_FormRecord43.item11,
dbo.KS_FormRecord44.item0 AS Expr1, dbo.KS_FormRecord44.item1, dbo.KS_FormRecord44.item4, dbo.KS_FormRecord44.item6 AS Expr2, dbo.KS_FormRecord44.item7 AS Expr3,
dbo.KS_FormRecord44.item3, dbo.KS_FormRecord45.item0 AS Expr6, dbo.KS_FormRecord45.item1 AS Expr7, dbo.KS_FormRecord46.item0 AS Expr8
FROM dbo.KS_FormRecord43 INNER JOIN
dbo.KS_FormRecord44 ON dbo.KS_FormRecord43.RecordID = dbo.KS_FormRecord44.CopyNO INNER JOIN
dbo.KS_FormRecord45 ON dbo.KS_FormRecord43.RecordID = dbo.KS_FormRecord45.CopyNO INNER JOIN
dbo.KS_FormRecord46 ON dbo.KS_FormRecord43.RecordID = dbo.KS_FormRecord46.CopyNO INNER JOIN
dbo.KS_FormRecord47 ON dbo.KS_FormRecord43.RecordID = dbo.KS_FormRecord47.CopyNO
ORDER BY dbo.KS_FormRecord43.AddDate DESC