Oh Yea...so it does..... HMM (maybe...)
SELECT TAB WITH WHEN STATUS = "A" AND STATUS="B" TO 1 SELECT TAB WITH WHEN STATUS = "B" AND ST_DATE = "" TO 2 MERGE.LIST 1 UNION 2 George > -----Original Message----- > From: [email protected] [mailto:owner-u2- > [email protected]] On Behalf Of Larry Hiscock > Sent: Wednesday, February 18, 2009 3:37 PM > To: [email protected] > Subject: RE: [U2] Need help with SELECT limiting MV > > Nope. The original post requested a method to get a list of IDs when > both A > and B appear in the multivalued STATUS field, AND the ST_DATE value > ASSOCIATED with the "B" STATUS was blank. > > Larry Hiscock > Western Computer Services ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
