注册 登录
编程论坛 SQL Server论坛

SQL语句的问题!为什么执行后提示错误!

花渊美步 发布于 2008-10-09 11:21, 1294 次点击
SELECT getOrgRefNo([RefNo]) AS FC_RefNo, FinalConfirm.PONO, FinalConfirm.Rev, FinalConfirm.B_QTY, FinalConfirm.DelDate, FinalConfirm.FOBDate
FROM FConf_Detail INNER JOIN FinalConfirm ON (FConf_Detail.PONO = FinalConfirm.PONO) AND (FConf_Detail.Rev = FinalConfirm.Rev)
WHERE (((getOrgRefNo([RefNo]))<>getOrgRefNo([forms]![F_FConf]![cboRefNo])));

getOrgRefNo是一个方法:
Function getOrgRefNo(str As String) As String
Dim i As Integer
i = InStr(1, str, "-")
If i > 0 Then
    getOrgRefNo = Left(str, i - 1)
Else
    getOrgRefNo = str
End If
End Function

但是执行后总是提示错误:
特定字段'[RefNo]'可以参考SQL语句From字句列表中的多个表!

请教如何解决这个问题!!!
4 回复
#2
makebest2008-10-09 14:27
是不是这个字段在几个表中都有, 你需要明确指出哪个表的, 如 "表1.RefNo"
#3
宠物在线2008-10-10 15:28
初学者,来学习了
#4
西风独自凉2008-10-11 16:57
SELECT getOrgRefNo([在這里加上表名.RefNo]) AS FC_RefNo, FinalConfirm.PONO, FinalConfirm.Rev, FinalConfirm.B_QTY, FinalConfirm.DelDate, FinalConfirm.FOBDate
FROM FConf_Detail INNER JOIN FinalConfirm ON (FConf_Detail.PONO = FinalConfirm.PONO) AND (FConf_Detail.Rev = FinalConfirm.Rev)
WHERE (((getOrgRefNo([RefNo]))<>getOrgRefNo([forms]![F_FConf]![cboRefNo])));

getOrgRefNo是一个方法:
Function getOrgRefNo(str As String) As String
Dim i As Integer
i = InStr(1, str, "-")
If i > 0 Then
    getOrgRefNo = Left(str, i - 1)
Else
    getOrgRefNo = str
End If
End Function
1