Thnx everyone for replies. James, I will take a look at inner-join documentation.
Sam, SQL view with distinct SQL query and then build view form on top of it also sounds like a good option. I will check it out. Regards, Chintan. --- On Fri, 7/16/10, Sam Rx <[email protected]> wrote: From: Sam Rx <[email protected]> Subject: Re: SQL equivalent of DISTINCT in Remedy To: [email protected] Date: Friday, July 16, 2010, 3:26 PM ** i have seen something very similar .. we had to publish a webservice with unique records however on our form we had duplicates records. as a workaround..we created a SQL view in the DB (using distinct sql query ).. Created a View form on arserver and then finally created a Webservice on the view form and it worked perfectly.. Thanks, Sam On Fri, Jul 16, 2010 at 3:30 PM, Chintan Shah <[email protected]> wrote: ** 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. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
