28,391
社区成员
发帖
与我相关
我的任务
分享select问题，帮忙看看吧
id = request.QueryString("id")
sql="select HanagaMembertempTable.* from HanagaMemberTable WHERE HanagaMemberTable.id = HanagaMemberTable.'"& id & "'"
提示：
The column prefix 'HanagaMembertempTable' does not match with a table name or alias name used in the query.
错在何处？？
sql="select HanagaMembertempTable.* from HanagaMemberTable WHERE HanagaMemberTable.id = HanagaMemberTable.'"& id & "'"
提示：
The column prefix 'HanagaMembertempTable' does not match with a table name or alias name used in the query.
错在何处？？
...全文
请发表友善的回复…
发表回复
chyhit 2001-08-27
- 打赏
- 举报
HanagaMembertempTable<>HanagaMemberTable
HanagaMember(temp)Table
HanagaMember(temp)Table
asp3 2001-08-27
- 打赏
- 举报
呵呵，同意楼上，怎么来往了
15年老程创业中 2001-08-27
- 打赏
- 举报
sql="select HanagaMembertempTable.* from HanagaMemberTable WHERE HanagaMemberTable.id = '"& id & "'"
iamxia 2001-08-27
- 打赏
- 举报
select HanagaMembertempTable.*
from HanagaMemberTable, HanagaMembertempTable
WHERE HanagaMemberTable.id = HanagaMemberTable.'"& id & "'"
from HanagaMemberTable, HanagaMembertempTable
WHERE HanagaMemberTable.id = HanagaMemberTable.'"& id & "'"
