I have two different tables(A & in SDE, which are having a common field to maintain relationship between the tables. I have requirement like finding the relation records in table B with respect to the records in table A. In table B it may contains one or more (max 4) records will available. After finding the relationship reords, then merge the fields of relation records to record in table A.
Can anyone please suggest of how to approach my requirement.
Thanks,
Seshu