Question Outer Join To Derived Table

Steve D

New Member
Hi,
I have a question that seems straightforward in MSSQL Sever, but I can't figure it out in Progress SQL.
I'm trying to do an outer join to a derived table / sub query. e.g.

select tabA.Col1, tabDerived.Col1
From tabA
Left Outer Join
(select tabB.Col1, tabB.Col3 From tabB where tabB.Col2 ='abc') as tabDerived
On tabA.Col3 = tabDerived.Col3

I've been trying for AGES!
I actually need to do a derived table to sum up a group of rows in a table, and then outer join to it.
Can anyone help me with the syntax?

Thanks,
Steve
 
Top