What do the *= and =* operators do in T-SQL?
sql-server, t-sql
Solution
That is the old and no longer recommended way of specifying table joins.
The modern equivalent to what you're seeing would be:
SELECT *
FROM foo_table
LEFT JOIN bar_Table ON foo_table.id = bar_table.fac_id
Problem
Possible Duplicate: SQL: What does =* mean? I am going through some legacy code and found a query like this: ``` SELECT * from foo_table, bar_Table where foo_table.id *= bar_table.fac_id ``` What does the *= operator do?