Skip to Content
0
Former Member
Mar 04, 2008 at 06:35 PM

Table Joins

20 Views

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