Thank you, Hank. Now that I know the name, it is easier to Google and find all kinds of postings.

>Hi Dmitry,
>
>this is called a "join select". For example, https://stackoverflow.com/questions/51750160/select-from-table-join-select-in-visual-foxpro
>
>enjoy,
>
>Hank
>
>>Hi,
>>
>>How I would create a SQL Select for the following case:
>>Table 1
>>

>>PART_NO   PART_PK    PART_QTY
>>"123"          1                 34
>>"ABC"         2                 0
>>"NBZ"         3                 12
>>

>>
>>Table 2
>>

>>PART_PK       QTY
>>1                    3
>>1                    4
>>1                    10
>>3                     1
>>2                     6
>>3                     2
>>2                     35
>>

>>
>>Resulting query should be
>>

>>PART_NO         PART_QTY      ACT_QTY   (Act Qty is SUM of QTY in Table 2 field QTY)
>>"123"                34                   17
>>"ABC"               0                      41
>>"NBZ"              12                     3
>>

>>
>>TIA
>>
>>UPDATE: I know that the SQL Select should consist of two SQL Select:
>>

>>select PART_NO, PART_QTY ..... (SELECT SUM(QTY) AS ACT_QTY from Table2 GROUP BY PART_PK) AS ACT_QTY FROM Table1
>>

>>
>>But I don't know how to "connect" the main SQL Select with the SUB-SQL Select