I have a service 1 which accesses database tables A and B and a service 2 which accesses database tables C and D.
There is a one to many relationship between tables A and C. But as per the rules of SOA, a service should be autonomous so this relationship should be satisfied by service calls. Now if I want to return all data of tables A join table C from an operation of Service 1 how will I accomplish this.

a. Joining the 2 tables is ruled out.
b. One option is defining a GetOperation in Service 2 which will accept the ID and return a record. Doing a foreach will then give me all data of Table C. This would be highly inefficient?

What is the right way to design for such a situtation?

Vipul Shah