>>>>Don't get it.
>>>>Some example data and desired result?
>>>
>>>Here a sample code I am playing with:
>>>
>>>CREATE CURSOR Table1 (pk_fld i, task_no i)
>>>INSERT INTO table1 VALUES (1,1)
>>>INSERT INTO table1 VALUES (1,2)
>>>CREATE CURSOR Table2 (task_no i, flda c(1), fldb c(1))
>>>INSERT INTO table2 VALUES (1,"A","B")
>>>INSERT INTO table2 VALUES (2,"C","D")
>>>INSERT INTO table2 VALUES (3,"C","F")
>>>INSERT INTO table2 VALUES (4,"K","I")
>>>
>>>
>>>Keep in mind that the above case has more records in Table2 than in Table 1 and for this FULL JOIN seem to work. But I need to test it in the case when Table1 has more records than Table2.
>>
>>OK, and what you want from this?
>
>I want the result to be
>pk_fld task_no flda fldb
>1 1 "A" "B"
>1 2 "C" "D"
>and so on.
>
>But here is another scenario.
>
>Say Table1 has the following records:
>INSERT INTO table1 VALUES (1,1)
>INSERT INTO table1 VALUES (1,2)
>INSERT INTO table1 VALUES (1,2)
>INSERT INTO table1 VALUES (1,2)
>INSERT INTO table1 VALUES (1,2)
>(that is a few records repeat both the PK and TASK_No). then the result should be:
>pk_fld task_no flda fldb
>1 1 "A" "B"
>1 2 "C" "D"
>1 2 "C" "D"
>1 2 "C" "D"
>1 2 "C" "D"
>
>Do I illustrate it clear? It seems like FULL JOIN works but I want to be sure.
Except for the weird naming convention, I think FULL JOIN will give you the desired result.
If it's not broken, fix it until it is.
My Blog