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