user(user_id,user_name) buy(buy_id,buy_user,handle_man)
拥护ID 用户名 购买单号 购买用户ID 负责用户ID
select * from buy 检索出来的buy_user和handle_man都是用户的ID,想把他变为用户名
SQL:select buy_id,
buy_user_name=(select user_name from user where user_id=buy.buy_user),
handle_user_name=(select user_name from user where user_id=buy.handle_man)
from buy
where buy_id=:buy_id
出现access violation at address 1F472FB3 in module'msado15.dll'.read of address 8BEC8B5Daccess violation at address 77FCB3AD in module' ntdll.dll'.Write of address 00000000
之类的DLL出错提示,初步测试好象是加上WHERE 条件有问题,不知道怎么改?这条SQL怎么写?
拥护ID 用户名 购买单号 购买用户ID 负责用户ID
select * from buy 检索出来的buy_user和handle_man都是用户的ID,想把他变为用户名
SQL:select buy_id,
buy_user_name=(select user_name from user where user_id=buy.buy_user),
handle_user_name=(select user_name from user where user_id=buy.handle_man)
from buy
where buy_id=:buy_id
出现access violation at address 1F472FB3 in module'msado15.dll'.read of address 8BEC8B5Daccess violation at address 77FCB3AD in module' ntdll.dll'.Write of address 00000000
之类的DLL出错提示,初步测试好象是加上WHERE 条件有问题,不知道怎么改?这条SQL怎么写?
解决方案 »
- 如何替换ListView中某行的某列
- 在线求助:DLL释放&关于窗体皮肤制作的资料 Delphi
- 跪求一查询语句~~!!!!!各位老大~~拜谢了~~!
- 新手提问:如何实现打印。
- 如果数据库中的某个表的结构不能确定(一些字段可能会变化),请问可不可以在Delphi中用sql语句createtbale创建该表?用此方法麻烦不?不
- 已得到edit1的handle,如何自动在edit1中输入字符??-----用api函数!
- 请问如何将动态创建的控件放在PANEL上,代码如下.......
- 关于TDBChart
- 在Delphi下有没有SAX控件?如何用?
- 更正,no visual c,delphi it is,和速达2000几乎完全一样的表单录入控件!!
- 如何减少程序对CPU的占用率,高手指教!
- 如何利用WebBrowser保存网页,但不打开"另存为"对话框按路径和指定文件名保存整个网页?
select a.*, b.user_name as buy_name, c.user_name as handle_name
from buy a, user b, user c
where a.buy_user=b.user_id
and a.handle_man=c.user_id
select a.*, b.user_name as buy_name, c.user_name as handle_name
from buy a, user b, user c
where a.buy_user=b.user_id
and a.handle_man=c.user_id这样好象不行哦,我那buy_user和handle_man都可为空的
from buy a, user b, user c
where a.buy_user=b.user_id
and a.handle_man=c.user_id
and a.buy_user is not null
and a.buy_user<>''
and a.handle_man is not null
and a.handle_man<>''注意引号的用法,如果buy_user,handle_man为空的话,没有什么实际意义吧
BDE是没问题的
select a.*, b.user_name as buy_name, c.user_name as handle_name
from buy a, user b, user c
where a.buy_user*=b.user_id
and a.handle_man*=c.user_id