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

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

Reply via email to