SQL NULL Pitfalls: Why NOT IN Returns Zero Results and 3 Points Where MySQL and Oracle Behaviors Diverge

Introduction"I want to list customers who haven't ordered, but I get zero results," or "The count doesn't match when I ...
Simon Fraser University

Using a Pass-Through Query in a Subquery

Note: This example uses a Version 6 view descriptor with the Pass-Through Facility to access DBMS data. Beginning in Version 7, you can associate a libref directly with your DBMS data and use the ...