Creating Where Clause With Common Keys !!

select 'and a.'||a.fieldname||' = b.'|| a.fieldname from PSKEYDEFN a,PSKEYDEFN b where
a.indexid='_' and
a.recname='<RECORD1>'
and b.indexid='_' and
b.recname='<RECORD2>' and a.fieldname=b.fieldname

Views: 38

▶ Reply to This

Replies to This Discussion

Permalink Reply by kristen on July 9, 2017 at 1:29pm

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)

RSS

PeopleSoft Jobs in US

Groups

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service