On Tue, Nov 15, 2011 at 3:33 AM, Dave Crozier <[email protected]> wrote: > Can't you make the query simpler by actually joining the nddiagnosen table in > the main body as follows: > --------------------
Exists( ) are an implied join and are the preferred syntax for a better execution plan. I saw this but was just out to watch the Packers football game. The missing pieces are setting that implied join properly. -- Stephen Russell 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmy+jukmpdsvfxs+uiguk_358b2_rn2thqja9x4znhx5...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
