>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

Dmitry,

A single statement should suffice, I think:

SELECT T1.PART_NO, T1.PART_QTY, SUM(T2.QTY) ;
	FROM T1 INNER JOIN T2 ON T2.PART_PK = T1.PART_PK ;
	GROUP BY 1, 2