Select No1,Name,
IsNull((Select Sum(ml) From juan Where No1=Main.No1),0) As ml
From Main
IsNull((Select Sum(ml) From juan Where No1=Main.No1),0) As ml
From Main
解决方案 »
- 第三方组件,有source目录和文件,是否可以将有些英文的内容改成中文的?
- 关于dbchart
- 今天自己尝试做控件!但是不知道为什么我的控件安装完以后在控件面板看不见!请帮帮忙!谢谢!
- excel的数据导入到sql server中
- 如何将'京'字编码成'BEA9'的GB编码???
- ICS 的FTP控件问题:怎样建目录,我这样做不出错,但是就是建不出来:
- 那位大侠能给一段delphi下用opengl显示字符的程序(2D、3D均可)
- 求一段scanline的示例程序
- 学习:哪位前辈能详细讲解一下TreeView的使用方法
- 将常用的程序的快捷键直接拖入快捷工具栏中
- 我怎么回复不了帖子了啊?
- 关于数据集赋值的问题。。。
IsNull((Select Sum(ml) From juan Where No1=Main.No1),0) As ml
From Main
where (Select Sum(ml) From juan Where No1=Main.No1)>0
and (Select Sum(ml) From juan Where No1=Main.No1)<500
Select No1,Name,
IsNull((Select Sum(ml) From juan Where No1=Main.No1),0) As ml
From Main
where (Select Sum(ml) From juan Where No1=Main.No1)>0
and (Select Sum(ml) From juan Where No1=Main.No1)<500
Select No1,Name,
IsNull((Select Sum(ml) From juan Where No1=Main.No1),0) As ml
From Main
where (Select Sum(ml) From juan Where No1=Main.No1)>0
and (Select Sum(ml) From juan Where No1=Main.No1)<500
SQL.Add('From main LEFT JOIN juan ON main.No1=juan.No1 ');
SQL.Add('where juan.ml>=:a ');
SQL.Add('Group By main.no1,main.name');
SQL.Add('order by ml desc');
parambyname('a').asinteger:=strtoint(edit1.text);
// parambyname('b').asinteger:=strtoint(edit2.text);
Select No1,Name,
IsNull((Select Sum(ml) From juan Where No1=Main.No1),0) As ml
From Main
where (Select Sum(ml) From juan Where No1=Main.No1)>0
and (Select Sum(ml) From juan Where No1=Main.No1)<500
Access数据库
Select No1,Name,
Iif((Select Sum(ml) From juan Where No1=Main.No1) is Null,0,(Select Sum(ml) From juan Where No1=Main.No1)) As ml
From Main
where (Select Sum(ml) From juan Where No1=Main.No1)>0
and (Select Sum(ml) From juan Where No1=Main.No1)<500