> On Dec 29, 2017, at 6:14 PM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote: > > Edson's original request was for a query that shows the FILENAMEs for the table. Which the query you provide does not do. > As for "qood" query, that is entirely an opinion. But a well informed one. Your query may work well enough for you, but when you're suggesting others rely on it you should expect more informed users to point out that it has some critical flaws - especially ones that might not be obvious to new users - lest others naively rely on it. > The query WILL show all files associated > with ALL tables. No, it won't. You're filtering out a bunch of things via the name of the table. That doesn't do the right thing. You're heading in the right direction, but the query you gave gets some things badly wrong. Listen to the criticism from others and you'll improve your knowledge and skills. There's absolutely nothing wrong with posting information that's not quite right, nor with getting feedback from others on what's wrong with it. Copping an attitude in response to that feedback is where things go downhill. Cheers, Steve
