您所在位置：主题：Select 与 union 不兼容？？？(已解决)
coffeenight
[专家分：230] 发布于 2008-06-10 09:18:00
[size=3]各位老师，下面这段代码
select ID as 学号,Wgymc as 科目,Wgycj as 成绩 from 成绩库 where wgycj>0;
union;
select ID as 学号,Ywk1mc as 科目,Ywk1cj as 成绩 from 成绩库 where ywk1cj>0;
union;
select ID as 学号,Ywk2mc as 科目,Ywk2cj as 成绩 from 成绩库 where ywk2cj>0;
into cursor 成绩表
出现程度错误提示：Select 与 union 不兼容
看不出是什么原因
请指教
谢谢[/size]
select ID as 学号,Wgymc as 科目,Wgycj as 成绩 from 成绩库 where wgycj>0;
union;
select ID as 学号,Ywk1mc as 科目,Ywk1cj as 成绩 from 成绩库 where ywk1cj>0;
union;
select ID as 学号,Ywk2mc as 科目,Ywk2cj as 成绩 from 成绩库 where ywk2cj>0;
into cursor 成绩表
出现程度错误提示：Select 与 union 不兼容
看不出是什么原因
请指教
谢谢[/size]
