correlated Queries in Netezza
How will I re-write correlated query in Netezza when I have a query like
below in oracle...
select table1.column1, case when table2.column2='xxxx' then ( select
max(table3.column3) from table3
where table3.column4=4 and table3.column2=table1.column2 and
table3.column3=table4.column4 ) else null end from table1,table2, table4.
No comments:
Post a Comment