select * from serbillmain a inner join
( select * from serBillMain c inner join
( select * from serBillMain where flag = 2 and billno = '20070101' )d
on c.phono = d.billno where c.flag = 3) b
on a.comno = b.billno where a.flag = 4
Sqlserver 报错:多次为b指定列Flag.
请问各位如何调整?
( select * from serBillMain c inner join
( select * from serBillMain where flag = 2 and billno = '20070101' )d
on c.phono = d.billno where c.flag = 3) b
on a.comno = b.billno where a.flag = 4
Sqlserver 报错:多次为b指定列Flag.
请问各位如何调整?
解决方案 »
- WebBrowser要显示一个远程数据库里的一个图片,在用ado下载过程中,WebBrowser如何先显示一个临时图片??下载完了又如何换成下载好的图片?
- 如何隐藏自己写的ocx,急急急!!!
- 数据库如何在添加字段的时候付初始值
- 请教:如何在DBGrid显示XML文件数据内容?
- 为什么我的opendialog不能返回filename,而返回了一个 $符号
- 怎么使用本地库,又同时用SQL查询呢
- 控制台程序???
- delphi中spcomm通讯控件的使用
- 开发三层数据库
- 报表打印出现1899-12-30!!!!请帮我一把。
- 我自己想写个外挂让另外一个程序最小化,或隐藏窗体,难吗?
- 新手提问:关于查询界面的问题!
( select * from serBillMain c inner join
( select * from serBillMain where flag = 2 and billno = '20070101' )d
on c.phono = d.billno ) b
on a.comno = b.billno where a.flag = 4 and c.flag = 3
( select * from serBillMain c inner join
( select * from serBillMain where flag = 2 and billno = '20070101' )d
on c.phono = d.billno ) b
on a.comno = b.billno where a.flag = 4 and c.flag = 3
“c.flag = 3” A,B两表的连接中那里可以限定C的呀!
没为FLAG指定表
没为FLAG指定表
能否说祥细一点。
改成下面试试:
select a.* from serbillmain a inner join
( select c.* from serBillMain c inner join
( select * from serBillMain where flag = 2 and billno = '20070101' )d
on c.phono = d.billno where c.flag = 3) b
on a.comno = b.billno where a.flag = 4