Skip navigation
12860 Views 3 Replies Latest reply: Feb 4, 2010 7:39 AM by Amudha RSS
Amudha New Enzee 2 posts since
Feb 4, 2010
Currently Being Moderated

Feb 4, 2010 5:56 AM

Netezza Update

Hi All,

 

I want a equivalent neteeza update statement for the below mentioned Oracle update

 

UPDATE SHIPMENT   s1

SET ORIGIN_SIC_ID =

(SELECT sic.sic_id sic_id

  FROM sic_location sic

WHERE s1.orig_trmnl_sic_cd = sic.sic_code

and s1.ORIGIN_SIC_ID IS NULL

  )

WHERE EXISTS

(SELECT sic.sic_id sic_id

  FROM sic_location sic

WHERE s1.orig_trmnl_sic_cd = sic.sic_code

and s1.ORIGIN_SIC_ID IS NULL

  )

 

or basically some update staement which uses inline / subquery.

 

Thanks,Amudha

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 4 points
  • Helpful Answers - 2 points