Descending from Oracle 9i release 2, the WITH clause has been implemented. The WITH clause is like a temp table function that used widely and frequently in other database systems. It's too bad this clause surfaces so late, but to look on the good side, I am glad we finally have such a good and convenient syntax to organize more efficient queries. EXAMPLE: WITH temp_name AS ( select NVL(column_name,'') as CN from table_a where ..... ) select .... from table_b join temp_name on ...
query of queries simple example : <!--- Main query which will be used later. ---> <cfquery name="qry_apply_list" datasource="#application.odbc#"> /** Comments */ select jobno,count(jobno) cnt from apply_list group by jobno </cfquery> <!--- Query from main query.
Baseball Basics: Lingo A fan's guide to commonly-used terms and phrases. ace -- A team's best starting pitcher. alley-- The section of the outfield between the outfielders. Also "gap."