神马品牌网ul衣服标志图片:求一个SQL语句
来源：百度文库 编辑：神马品牌网 时间：2024/05/08 03:11:38
返回字段：STANAME,TYPENAME,HDNAME,TYPENAME
from STADEF, STATYPE, HDIDDEF, HDTYPE
查询条件 STADEF.STATYPE = STATYPE.STATYPE
STADEF.STAID = HDIDDEF.STAID
HDIDDEF.DTYPE = HDTYPE.DTYPE"
我写的语句是：rs.Source = "select STANAME,TYPENAME,HDNAME,TYPENAME from STADEF, STATYPE, HDIDDEF, HDTYPE where STADEF.STATYPE = STATYPE.STATYPE and STADEF.STAID = HDIDDEF.STAID and HDIDDEF.DTYPE = HDTYPE.DTYPE"
Set rs.ActiveConnection = cn
rs.Open
运行时rs.Open出错，说未明确定义列
怎么回事？
from STADEF, STATYPE, HDIDDEF, HDTYPE
查询条件 STADEF.STATYPE = STATYPE.STATYPE
STADEF.STAID = HDIDDEF.STAID
HDIDDEF.DTYPE = HDTYPE.DTYPE"
我写的语句是：rs.Source = "select STANAME,TYPENAME,HDNAME,TYPENAME from STADEF, STATYPE, HDIDDEF, HDTYPE where STADEF.STATYPE = STATYPE.STATYPE and STADEF.STAID = HDIDDEF.STAID and HDIDDEF.DTYPE = HDTYPE.DTYPE"
Set rs.ActiveConnection = cn
rs.Open
运行时rs.Open出错，说未明确定义列
怎么回事？
要指出这四个列分别出自哪个表STANAME,TYPENAME,HDNAME,TYPENAME
如：
select A.Name,A.Age,B.ClassID from User as A,Class as B where A.UserID=B.UserID
楼上说的对，这种关连查询要指明出处的。