Yet another learning tip (MSSQL)

select * from ju_test_1 j1, ju_test_2 j2 where
j1.id *= j2.id

is equivalent to:

select * from ju_test_1 j1 left outer join ju_test_2 j2 on
j1.id = j2.id

Thing to note is that non-ANSI is available only for 80 compatibility or lower. *Strongly recommended to rewrite using ANSI outer join operators.

*****
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.