On Tue, 13 Feb 2007, David Romerstein wrote: > SELECT p.Path, fn.Filename FROM p Path, fn Filename, f File WHERE > fn.Filename LIKE '%.mp3' AND f.FilenameID = fn.FilenameID and p.PathID = > f.PathID INTO OUTFILE '/tmp/mp3_filez.out';
Ugh. I have this bass ackwards, and I screwed up a column name. SELECT p.Path, fn.Name FROM Path p, Filename fn, File f WHERE fn.Name LIKE '%.mp3' AND f.FilenameID = fn.FilenameID and p.PathID = f.PathID INTO OUTFILE '/tmp/mp3_filez.out'; *sigh* - that'll teach me to not check my work *before* I post... -- D ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
