select Subscribers.ID from UsersData inner join Subscribers on UsersData.ID=Subscribers.UserID where ListID=3 and Email='[email protected]'
select Subscribers.ID from UsersData inner join Subscribers on UsersData.ID=Subscribers.UserID where ListID=3 and cast(Email as varchar)='[email protected]'类型不一致怎么比较啊
select Subscribers.ID from UsersData inner join Subscribers
on UsersData.ID=Subscribers.UserID
where ListID=3 and Email='[email protected]'
出现以下错误:
消息 208,级别 16,状态 1,第 1 行
Invalid object name 'UsersData'.
先use 数据库名。。提示没找到这张表,只要表确实存在,那就是表不在你当前的库里面
消息 402,级别 16,状态 1,第 1 行
The data types text and varchar are incompatible in the equal to operator.
on UsersData.ID=Subscribers.UserID
where ListID=3 and Email='[email protected]'
on UsersData.ID=Subscribers.UserID
where ListID=3 and cast(Email as varchar)='[email protected]'类型不一致怎么比较啊