• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Question Outer Join To Derived Table

#1
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