Good News Everybody!
The new search engine is LIVE!
Please report any problems to david (at) midrange.com.
|
Jay Vaughn wrote:
6. SQL statement help (Jay Vaughn) The following statement executes fine... however, I want results based onQDINST not being found in BANKINST... I simply tried changing "IN" to "NOTIN" and it didn't like it... any suggestions? SELECT DISTINCT QDSTCD CONCAT DIGITS(QDAREA) CONCAT DIGITS(QDBANK) FROM BRDETAIL WHERE QDDGRP = 'DEP' AND QDVERI = 'N' AND QDCLVL = '5' AND QDINST IN(SELECT QIINST FROM BANKINST)
midrange.com
Jay:
Perhaps
select ... from ... where ...
AND not QDINST IN(SELECT QIINST FROM BANKINST)
will work. I'd swear I recall this form working when [ QDINST not IN( ]
wouldn't work at times in the past. Perhaps due to DB2 group PTF levels,
perhaps just some prior releases.
What version of OS/400 are you using? What's the DB2 group level? Tom Liotta
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.
