I think that the temp use is often from people who have limited their SQL
stuff to that learned by Query/400. Query to an outfile, query that to
another outfile, finally query that. Three queries must be run in
sequence. Ouch. If you're doing that, you're doing it wrong. I think
this is what you were referring to replacing with common table

Fear of learning parameter markers and stuff often leads people to
populating a temporary table and then joining that to the raw data for
their 'select'. Again, another Query/400 trick.

Rob Berendt

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].