BTW this is a 30+ year old issue and combining the fields has always been the answer. ----- Original Message ----- From: "Noah Hart" <n...@lipmantpa.com> To: <u2-users@listserver.u2ug.org> Sent: Tuesday, February 17, 2009 1:26 PM 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 > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/