Make sure you a link associated between STATUS and ST_DATE Attribute #7 IE.
STATUS 0001: D 0002: 4 0003: 0004: STATUS 0005: 10R 0006: M 0007: LINK1 ST_DATE 0001: D 0002: 5 0003: 0004: DATE 0005: 10R 0006: M 0007: LINK1 Now the WHEN clause should work. SELECT TAB WITH (STATUS = "A" OR STATUS = "B") AND WHEN ST_DATE = "" btw (STATUS Can't be "A" and "B", you need OR to select either "A" or "B") George > -----Original Message----- > From: [email protected] [mailto:owner-u2- > [email protected]] On Behalf Of Noah Hart > Sent: Tuesday, February 17, 2009 1:27 PM > To: [email protected] > Subject: [U2] Need help with SELECT limiting MV > > I have a table with a MV status code and date field. > > I am trying to select just those records that have both status code A > and B and when the date associated with code B is blank > > I tried > > SELECT TAB WITH STATUS = "A" AND STATUS = "B" AND ST_DATE = "" > > But this will select records which might have a blank date for status > "C" > > > I see the data properly with a LIST WHEN command, but I want the > matching @IDs in a list > > LIST TAB WITH F2 = "A" WHEN F2="B" AND F3="" F1 F2 F3 > > There must be a simple way to do this, but I'm just not getting it. > > Ideas? > > Thanks, > > Noah > > > > > CONFIDENTIALITY NOTICE: > This message may contain confidential and/or privileged information. If > you > are not the addressee or authorized to receive this for the addressee, > you > must not use, copy, disclose, or take any action based on this message > or any > information herein. If you have received this message in error, please > advise > the sender immediately by reply e-mail and delete this message. Thank > you for > your cooperation. > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
