Re: Highly obscure and erratic

On Tue, 18 Jun 2002, Stephan Szabo wrote:

> select dbmedia.* from dbmedia, wdmedia where wdmedia.word='whatever' and
>   dbmedia.id=wdmedia.id;

I think all of us suggesting EXISTS in the case of this query were
complete tards, me included.  Looks like a simple join will suffice
nicely, and now that I look at it, I wonder why you're the first one to
see it.  Good job!

But that'll definitely help.  Varun, if you're listening, use this!

--
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
| Shaun M. Thomas                INN Database Administrator           |
| Phone: (309) 743-0812          Fax  : (309) 743-0830                |
| Email: sthomas@townnews.com    AIM  : trifthen                      |
| Web  : www.townnews.com                                             |
|                                                                     |
|     "Most of our lives are about proving something, either to       |
|      ourselves or to someone else."                                 |
|                                           -- Anonymous              |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+