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_ 


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

Reply via email to