Oh yes, I forgot to add that, I was answering in a hurry doing something else...didn't read the requirement again...LOL. Thanks
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Wednesday, 23 January 2008 8:38 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Selection help David Very close.. just need the uniqueness adding. How about simply: SELECT DISTINCT CODE FROM UNNEST LOOKUP.TABLE ON CODE WHERE @ID = 'XYZ' ORDER BY CODE; Code...... AAA BBB CCC 3 records listed. Brian ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/