SQL OUTER JOIN sample uses - SQL Server: Covering today's SQL Server topics

Find Missing Values Sometimes you just want to find what's missing. You do so by using an OUTER JOIN with a test for Null. Here are some "missing value" problems you can solve. "What products have never been ordered?" "Show me customers who have never ...

searchsqlserver.techtarget.com