Select t.id,t.arcloc ,t.cqr,t.cqxz,t.cqzl
From regyzdata t
Where t.arcloc In
(Select e.Id As arcloc
From wv_imagefile e
Where e.boxsn=1 And e.checked=1
Order By e.archno)
这条sql语句,如果去掉“Order By e.archno”的话,执行成功;
否则,就保“缺少右括号”。为什么呢?
From regyzdata t
Where t.arcloc In
(Select e.Id As arcloc
From wv_imagefile e
Where e.boxsn=1 And e.checked=1
Order By e.archno)
这条sql语句,如果去掉“Order By e.archno”的话,执行成功;
否则,就保“缺少右括号”。为什么呢?
Select id,arcloc,cqr,cqxz,cqzl
From regyzdata
Where arcloc In (Select Id
From wv_imagefile
Where boxsn = 1
And checked = 1);
排序字段至少要出现在 from 的表中。