>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.
Select Table1.PK_FLD, Table1.TASK_NO,Table2.FLDA, Table2.FLDB from Table1 ;
LEFT JOIN Table2 on Table2.TASK_NO = Table1.TASK_NO