×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
He asked to 'find all entries' which isn't much of a translation (to me at least) to SELECT. If he said 'change all entries' I'd go with UPDATE. Yeah there is some translation going on (find=select, change=update). If I showed the SQL to someone who didn't know the language syntax would they understand the exception join? IMHO this is the more readable statement and it probably has acceptable performance.
Exposing my preferences...
Paul Morgan
Principal Programmer Analyst
IT Supply Chain/Replenishment
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Pluta
Sent: Wednesday, August 31, 2011 11:51 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL question from an absolute SQL newbie
On 8/31/2011 10:06 AM, Morgan, Paul wrote:
Joe,
It's funky because reading the SQL statement requires a 'translation' from the exception join to the requirement of 'not in file'. I prefer not exists as a more straightforward (easier to understand) implementation of the requirement.
No more of a translation than having to use "SELECT" even though you're
not actually selecting anything. You may not prefer the syntax, but
that doesn't necessarily make it funky. :)
midrange.com
