selectsql := 'select bargainname,modifyname,signatory,relaionunit,correlationunit,idea,state,statrdate,enddate,content,signaturedepartment,signaturetime from tabmodify where bargainname in (select top 1 bargainname from tabbargain where tabbargain.bargaincode=tabmodify.bargaincode) and ' + mysql
//不是很清楚你的原意,但你那样写肯定是不行的。
//不是很清楚你的原意,但你那样写肯定是不行的。
解决方案 »
- delphi7 数据无法删除
- 在线紧急求助:如何使用dblistbox
- ADOQuery1.SQL.Add可以多次使用吗 ADOQuery1.Open是不是全部执行了
- 发送邮件问题
- 一个比较好的毕业设计,应该是怎样子?
- 各位朋友好,我有几个小问题要请教一下!
- 用了SetLayeredWindowAttributes不可以在MTV上显示出来? 500分
- 請問哪有mail2000和askmail控件下載?
- 那位有spcomm控件的使用资料!!
- 帮我找Partition Magic的下载地址.谢了.(华军软件园的这个软件是DEMO版本不能用)
- (150分)有没有人会啊。记录结构变了,读写如何一一对应呢?150分那。
- 你简直就是在抢我的可用分!!!555555555555555
begin
close;
sql.Clear ;
selectsql:='select bargainname=(select top 1 bargainname from tabbargain where tabbargain.bargaincode=tabmodify.bargaincode),modifyname,signatory,relationunit'
+' correlationunit,idea,state,statrdate,enddate'//这里开始那里要加空格分开阿!!
+' content,signaturedepartment,signaturetime'//这里开始那里要加空格分开阿!!
+' from tabmodify where '+mysql;//调用mysql得到选择的条件//这里开始那里要加空格分开阿!!
sql.text:=selectsql;
open;
begin
close;
sql.Clear ;
selectsql:='select bargainname=(select top 1 bargainname from tabbargain where tabbargain.bargaincode=tabmodify.bargaincode),modifyname,signatory,relationunit,'//这里最后还要增加一个逗号
+' correlationunit,idea,state,statrdate,enddate,'//这里开始那里要加空格分开阿!!最后还要增加一个逗号
+' content,signaturedepartment,signaturetime'//这里开始那里要加空格分开阿!!
+' from tabmodify where '+mysql;//调用mysql得到选择的条件//这里开始那里要加空格分开阿!!
sql.text:=selectsql;
open;
按你所说的改来了,
但还是有错误
提示说是select附近语法有错
是不是query有能同时连两个表呢
如下
select top 1 bargainname from tabbargain where tabbargain.bargaincode=tabmodify.bargaincode
sql.Clear ;
selectsql:='select bargainname=select top 1 bargainname from tabbargain where bargaincode in (select bargaincode from tabbargain), modifyname,signatory,relationunit,'
+' correlationunit,idea,state,startdate,enddate,'
+' content,signaturedepartment,signaturetime'
+' from tabmodify where '+mysql;//调用mysql得到选择的条件
sql.text:=selectsql;
open;
还是不对
以上中的字段如下
bargainname在表tabbargain,其它的都在tabmodify中
我的原意是想把查出来的tabmodify的所有字段现加上其对应的tabbargain中的tabbargain中
bargainname查出来并在dbrgid中显示
两表以bargaincode
sql.Clear ;
selectsql:='select (select top 1 bargainname from tabbargain where bargaincode=tabmodify.bargaincode) as aaaaa, modifyname,signatory,relationunit,'
+' correlationunit,idea,state,startdate,enddate,'
+' content,signaturedepartment,signaturetime'
+' from tabmodify where '+mysql;//调用mysql得到选择的条件
sql.text:=selectsql;
open;
sql.Clear ;
selectsql:='select bargainname=(select top 1 bargainname from tabbargain where bargaincode in (select bargaincode from tabbargain)), modifyname,signatory,relationunit,'
+' correlationunit,idea,state,startdate,enddate,'
+' content,signaturedepartment,signaturetime'
+' from tabmodify where '+mysql;//调用mysql得到选择的条件
sql.text:=selectsql;
open;
在select top 1处加了()就ok了
呵呵,谢谢千两狂死郎
close;
sql.Clear ;
selectsql:='select bargainname=(select top 1 bargainname from tabbargain where bargaincode in (select bargaincode from tabbargain)), modifyname,signatory,relationunit,'
+' correlationunit,idea,state,startdate,enddate,'
+' content,signaturedepartment,signaturetime'
+' from tabmodify where '+mysql;//调用mysql得到选择的条件
sql.text:=selectsql;
open;