How about something like: SELECT TAB WITH STATUS = "A" AND WITH EVAL 'IF STATUS = "B" THEN IF ST_DATE = "" THEN "1" ELSE "0" ELSE "0" ' = "1" ' HTH, Bill ______________________________________________________________________
From: Noah Hart <[email protected]> Sent: 2/17/2009 10:26 AM 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/
