[thelist] Re: SQL gurus

Theodore Serbinski stanson at gmail.com
Fri Mar 25 15:11:11 CST 2005


> You can do it without the join like this:
> 
> select date, mileage, notes, notes like '%whatever%' as match from m;

Oh sweet, did not know I get the query to be that simple!

I'm glad I asked, my long OUTER JOIN is now only a few characters
long, thanks all!

ted


More information about the thelist mailing list