>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