如题，我编写了select 仓库.仓库号,城市,面积,职工号,工资
from 仓库,职工
where 仓库.仓库号*=职工.仓库号
然后就下面提示我Msg 4147, Level 15, State 1, Line 3
The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.
是不是语法改了
from 仓库,职工
where 仓库.仓库号*=职工.仓库号
然后就下面提示我Msg 4147, Level 15, State 1, Line 3
The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.
是不是语法改了
=* right join
select 仓库.仓库号,城市,面积,职工号,工资
from 仓库,职工
on 仓库.仓库号*=职工.仓库号 where ******