>>>>>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.
Please do not call my naming conventions names (pun intended). Thanks.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham