Hi Joe,

Thanks for the reply. This "create a view containing distinct values of B"
sounds intriguing. Is that something I can do with Dev Studio or do I have
to create that directly on the DB? I didn't see anything in the view
properties in Dev Studio.

Thanks.
Larry


On Wed, Aug 21, 2013 at 4:06 PM, Joe D'Souza <[email protected]> wrote:

> **
>
> It appears like you are looking for a join between A and distinct of B,
> which is only possible if you customize your system such that you actually
> create a view containing distinct values of B, and then use that to create
> a join with A.****
>
> ** **
>
> Otherwise as far as the AR System is concerned that second or third or
> fourth row it might see of 100 if you had that many, are separate rows. No
> way for it to know that you are seeking for distinct values.****
>
> ** **
>
> Joe****
>
> ** **
>  ------------------------------
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [email protected]] *On Behalf Of *L G Robinson
> *Sent:* Wednesday, August 21, 2013 2:14 PM
> *To:* [email protected]
> *Subject:* Join form question****
>
> ** **
>
> ** ****
>
> Hi Folks,****
>
> ** **
>
> I need some help with a join. I'm not sure if this is possible or not.****
>
> ** **
>
> In simple terms, I have two forms, Form A and Form B****
>
> ** **
>
> They have one field in common, lets call it X.****
>
> ** **
>
> Form A has the following values for X:****
>
> 100****
>
> 200****
>
> 300****
>
> ** **
>
> Form B has two fields X and Y.****
>
> There may be multiple entries in Form B where X is repeated:****
>
> ** **
>
>  X        Y****
>
> 100    20****
>
> 100    20****
>
> 100    30****
>
> 200    30****
>
> 200    30****
>
> 200    40****
>
> 300    20****
>
> ** **
>
> Is there a way to join these two forms together so that if I search for
> Y=20 I will get this:****
>
> ** **
>
> X****
>
> 100****
>
> 300****
>
> ** **
>
> instead of this:****
>
> ** **
>
> X****
>
> 100****
>
> 100****
>
> 300****
>
> ** **
>
> I have tried a number of variations on inner/outer and switching primary
> but I haven't been able to get what I want.****
>
> ** **
>
> Thanks for any suggestions you may have.****
>
> Larry****
>
> ** **
>
> ARS: 7.6.04 SP3 201201302357 on Solaris 10****
>
> Oracle 11.2.0.3.0****
>
> ** **
>
> ** **
>
> Larry Robinson****
>
> Remedy Developer/Admin****
>
> NC State University****
>
> Raleigh, NC****
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_ ****
>  _ARSlist: "Where the Answers Are" and have been for 20 years_

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Reply via email to