Advanced Search

Return to Snippet

Revision: 69867
at September 25, 2015 11:04 by ironcrema
Initial Code 
SELECT c.CustomerID 
FROM Sales.Customer AS c
LEFT OUTER JOIN Sales.SalesOrderHeaderEnlarged AS h
ON c.CustomerID = h.CustomerID
WHERE h.CustomerID IS NULL;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Reemplaza el NOT IN

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
SQL SERVER REEMPLAZO DE NOT IN - OUTER JOIN

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL