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