help me correct query ??

• cqldba

  SSC Enthusiast

  Points: 182

  More actions

  February 28, 2012 at 8:25 am

  #149083

  Below query is giving me this error:The multi-part identifier "dim_pt_psp.pt_psp_pk" could not be bound bound. Severity 16

  UPDATE aa

  SET ps_vir = 1

  WHERE cpd_id IN ( '1-1WJ-456', '1-14M-618' )

  AND dim_pt_psp.pt_psp_pk = 1

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  February 28, 2012 at 8:54 am

  #1452665

  "aa" is the only table identifier on this query, so I guess this should do:

  UPDATE aa

  SET ps_vir = 1

  WHERE cpd_id IN ( '1-1WJ-456', '1-14M-618' )

  AND aa.pt_psp_pk = 1

  -- Gianluca Sartori