http://www.coderecipes.net/advanced-sql-tutorial.aspx<p>Advanced SQL tutorial gives you the most common toughest problems you have to face up to in database programming.</p>Sat, 12 Jan 2008 05:44:00 GMTen-UShttp://www.coderecipes.net/sql-union-tutorial.aspxTue, 01 Jan 2008 10:47:00 GMTSQL UNION Operator allows you to combine the match result sets of two (or more than two) select queries into a single table.http://www.coderecipes.net/sql-case-expression-tutorial.aspxMon, 31 Dec 2007 12:20:00 GMTSQL CASE expression is used as a kind of IF-THEN-ELSE statement.http://www.coderecipes.net/sql-intersect-operator-tutorial.aspxTue, 01 Jan 2008 10:22:00 GMTINTERSECT operator allows you to combine two table expressions into one and return a result set which consists of rows that appear in the results of both table expressions.http://www.coderecipes.net/sql-minus-except-operator-tutorial.aspxTue, 01 Jan 2008 10:40:00 GMTSQL MINUS or EXCEPT operator work on two table expressions. The result set takes records from the first table expression, and then subtract out the ones that appear in the second table expression. If the second table expression includes the records which are not appear in the first table expression, these records will be ignored.