Number2 Blog - myITforum : inner join

M@d Skillz - SMS Permissions - BITWISE "AND" with a PIVOT thrown in for pretty :)

jnelson — Tue, 20 Nov 2007 03:52:00 GMT

M@d SKILLZ ARTICLE ALERT! (This is gonna get cr@zy, if you have a helmet, now's the time to put it on) So I was trolling the forums here on MyITForum...(read more)

SQL Oddity - OUTER JOINs with criteria act like INNER JOIN

jnelson — Sat, 17 Nov 2007 04:33:00 GMT

SYMPTOMS You have a query with an OUTER JOIN (aka LEFT JOIN, RIGHT JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN), and you need to put filter criteria on the...(read more)