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