User Profile

Collapse

Profile Sidebar

Collapse
userdave
userdave
Last Activity: Nov 4 '08, 01:54 PM
Joined: Nov 4 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • userdave
    replied to Simple update Table query based on 2 tables joined
    in Oracle
    Well I was at the time, but I have now resolved whatever problems I had by using the..

    .... where TabeA.definitio n_id in (Select attribute_defin ition_id from tableB....

    statement.

    Thanks for taking the time to respond.

    Dave
    See more | Go to post

      Leave a comment:

    • userdave
      started a topic Simple update Table query based on 2 tables joined
      in Oracle

      Simple update Table query based on 2 tables joined

      Hi,

      Please can you assist me, I'm trying to execute some SQL to update 1 column to a constant value (50) in multiple rows in Table A based on an associated 'SOURCE' value in table B

      Table A joins to Table B based on the TableA.definiti on_id = TableB.Att_Def_ id

      like..

      update TableA
      set value =50
      where
      TableA.definiti on_id = TableB.Att_Def_ id
      and TABLEB.Source...
      See more | Go to post
      No activity results to display
      Show More
      Working...