I'll try it, I wonder what the difference is? What I was hoping to learn was an equivalent correlation to eliminate "in" syntax. I thought I'd read about using outer joins that accomplished the same thing, but don't recall where.
Thanks Ben On 5 Mar 2004 at 20:03, Lawrence Lustig wrote: > > I've pretty much eliminated subselects from inserts > > and updates by > > correlating the tables, but I have not figured out > > how to replace > > "NOT in (.....)". How would a person do that? > > Try NOT EXISTS (SELECT Statement) > -- > Larry > > __________________________________ > Do you Yahoo!? > Yahoo! Search - Find what you�re looking for faster > http://search.yahoo.com >
