Good News Everybody!
The new search engine is LIVE!
Please report any problems to david (at) midrange.com.
|
On Fri, 2004-09-24 at 18:21, Simon Coulter wrote: > On 25/09/2004, at 6:40 AM, Rich Duzenbury wrote: > > > fails: > > Column POSTDATE not in specified tables > > > > Anyone know what's up with that? > > Simple. Columns specified in the WHERE clause must be in at least one > of the underlying tables. Columns specified in the ORDER BY clause must > be in the result set. Thanks for the info, Simon. I double checked one of my other non-AS/400 sql databases, and it has the same restriction. However, the HAVING clause in the other database can be based on the result set, which throws an error on DB2/400. At least I can work around it. -- Regards, Rich Current Conditions in Des Moines, IA Scattered Clouds Temp 64.4F Winds out of the Southeast at 5mph
This mailing list archive is Copyright 1997-2026 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
