Why do I Want to Use a JOIN Clause?
Recently a friend of mine asked me why he should use a JOIN statement rather than adding extra criteria to the where clause. It’s an interesting question, and I thought…
SQL
Treatment of NULLs by Oracle & SQL Server
Oracle & SQL Server behave subtly differently when processing columns containing nulls. Consider the following series of SQL statements: CREATE TABLE tempone ( creditlimit NUMBER(6)); -- Oracle CREATE TABLE tempone…