Hi all, I need to update a number of procs and want to sanity check some of the code I am seeing. What I need is a basic chart to define or show the equivilent of the following: A *= B (used in where statement) B =* C (used in where statement) != These are the ones I found so far. Thanks!!
You're looking at old SQL syntax. The *= and =* operators have been replaced by outer joins. The old syntax was supported until fairly recently, not sure in which version it was actually dropped ... Not entirely sure about the != operator, but IIRC it's equivalent to <> (or "not equivalent to", LOL). Not sure if this was part of the old non-join syntax?
