Re: classic outer join problem

2005-05-24 Thread mfatene
Hi Hank, I think your problem is to find all the files under /uploads by a command like : cd /uploads ls -lR | grep ".doc" >files.txt then load the files.txt into a temporary table TEMPtable that you create for this issue (see http://dev.mysql.com/doc/mysql/en/load-data.html), after truncating it

Re: classic outer join problem

2005-05-24 Thread SGreen
Hank <[EMAIL PROTECTED]> wrote on 05/24/2005 05:02:47 PM: > I have a table of school class assignments with the following fields - > the first four fields are the primary key: > > Year (int) > Term (enum, "Spring", "Fall","Winter") > ClassID (int) > SectionID (int) > Attachement (varchar 225) >