>>>>>I am trying to figure out how to use a subquery in the following example:
>>>>>
>>>>>Table1
>>>>>PK_FLD, TASK_NO
>>>>>
>>>>>Table2
>>>>>TASK_NO, FLDA, FLDB
>>>>>
>>>>>I want the resulting query to have as many records as there are in Table1 adding columns FLDA and FLDB from
>>>>>Table2 according to the matching TASK_NO.
>>>>>
>>>>>My attempt at this query is as following
>>>>>

>>>>>Select Table1.PK_FLD, Table1.TASK_NO, T2.FLDA, T2.FLDB from Table1 where (select * from Table2 where 
>>>>>TASK_NO = Table1.TASK_NO) T2 
>>>>>

>>>>>
>>>>>But I get error of incorrect use of subquery. What am I missing? TIA.
>>>>
>>>>use JOIN instead of subquery.
>>>>

>>>>Select Table1.PK_FLD,;
>>>>       Table1.TASK_NO,;
>>>>       T2.FLDA,;
>>>>       T2.FLDB;
>>>>from Table1 ;
>>>>INNER JOIN Table2 T2 ON T2.TASK_NO = Table1.TASK_NO;
>>>>** You could use LEFT JOIN if you want ALL records from Table1 and only matching records from Table2
>>>>

>>>
>>>I am sorry that I probably mislead you (and Yuri) since I didn't indicate that I want records from Table2 (that do non have matching to Table1 on TASK_NO). That is, I want all records from Table1 and the records from Table2 that do not have matches. I think INNER or LEFT JOINT won't give me that. At least I tried.
>>>
>>>Thank you and Yuri.
>>
>>
>>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?