Thanks for your suggestions, I propose a query made with help of a friend of mine: SELECT CONCAT(Path.Path,Filename.Name) FROM Filename Inner Join File ON Filename.FilenameId = File.FilenameId Inner Join Path ON File.PathId = Path.PathId where (Filename.Name LIKE "%avi") OR (Filename.Name LIKE "%AVI") OR (Filename.Name LIKE "%mpeg") OR (Filename.Name LIKE "%MPEG") OR (Filename.Name LIKE "%mpg") OR (Filename.Name LIKE "%MPG");
Now, I bring up the "reasoner" (http://wggw.bellobello.it/macek.jpg) and will go to talk to some of my collegues :-P. Simone ------------------------------------------------------------------------------ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
