Solved

AS400 Query selection question

Posted on 2010-08-26
2
619 Views
Last Modified: 2013-12-06
I'm not able to get my selection correct and this is something that is need asap.... I would normally use sql, but need it in query.  

please see attached
query-selection.doc
0
Comment
Question by:lynn_harris
2 Comments
 
LVL 5

Accepted Solution

by:
stevebowdoin earned 500 total points
ID: 33534448
use "range" and "list"..

as soon as you put that "or" in there you start over...

Steve

ds.bmp
0
 

Author Closing Comment

by:lynn_harris
ID: 33534695
excellent.  List is great.  Thanks!!!
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In a recent article here at Experts Exchange (http://www.experts-exchange.com/articles/18880/PaperPort-14-in-Windows-10-A-First-Look.html), I discussed my nine-month sandbox testing of the Windows 10 Technical Preview, specifically with respect to r…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now