Hello, I have a table field that represents a view form. Now, I need to get only unique rows in that table.
The problem is for a particular ID(on view form) there could be multiple email addresses and I want to get DISTINCT email in table field before walking through it and extracting required infor. I dont see any option available under "Table/Tree Property" for doing this. In a nutshell, here's scenario. 1. View form pointing to an external DB that holds multiple email addresses as separate rows for a particular ID(this ID is different from primary key of table). 2. A table field that queries this view form with qualification: $ID$='ID'. 3. Now, this returns a result set that has multiple rows in it with column name of NAME,EMAIL. I can do table walk and get required information, but how do I extract only unique rows? e.g. if result set is as below ID NAME EMAIL SOME OTHER COLUMN 1 A X Z 1 B Y Z 1 A X P how can I refine it to just A-X, B-Y? Regardless of value in SOME OTHER COLUMN, I need to use only A-X,B-Y. Basically, I am looking for SQL equivalent of DISTINCT in Remedy that can be used with Table Field qual. Any help is appreciated. Thanks Chintan. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
