WithinsomanykindsofDMLstatementsinSQL,Ithinkfourkindsofthem,includingCaseWhen,LeftOuterJoin/LeftJoin/RightOuterJoin/RightJoin/InnerJoin,WITHASandUNION/UNIONALL,areessentialfortheDatabaseDeveloper.Infact,thereisakindofSQLstatementwhichmightbethetrumpcardtotheseniorsoftwarede