You're welcome. I had the exact same reaction when I learned the name. :)
>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