Hello experts,
We are using 3 tables like LINK,PARTNER & ORDER.
Client and GUID are the fields on which the join has done.
ORDER Client = LINK Client
LINK Client = PARTNER Client
ORDER GUID = LINK GUID
LINK GUID = PARTNER GUID
now i need to add a replace a field(ORDER)
New table is OPP .
it has both client and guid fields.
can any body tell me how to write a join condition
Thanks