|
Great! Glad I could help -- your problem looked very similar to one I was struggling with just last week, so the light bulb went off . . .! I haven't really figured _why_ this works yet, but it looks like the ORDER BY doesn't like being in the sub-select clause -- instead, it needs to be associated with the INSERT (for some reason). Maybe one of the SQL gurus can tell us the theory behind this? midrange-l@midrange.com writes: >Amazing. That worked. And all it involved was moving a parenthesis from >the end of the statement (after the word ONLY) to right after the file >name. > >Thank you. > >Rob Berendt Mike Naughton Senior Programmer/Analyst Judd Wire, Inc. 124 Turnpike Road Turners Falls, MA 01376 413-863-4357 x444 mnaughton@juddwire.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
