Update Query Help... - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Update Query Help...

oipoip Posts: 19Member
Greets,

Have a (hopefully) quick question.

How do I UPDATE one table based on criteria in another table?

All help will be greatly appreciated.

Thanks in advance.

Comments

  • infidelinfidel Posts: 2,900Member
    : Greets,
    :
    : Have a (hopefully) quick question.
    :
    : How do I UPDATE one table based on criteria in another table?
    :
    : All help will be greatly appreciated.

    Depends on what you want to do.

    [code]
    update table1 set
    column1 = (select sum(column4) from table2)
    [/code]

    [code]
    update table1 t1 set
    column1 = value1
    where exists (
    select 1 from table2 t2
    where t1.column3 = t2.column1
    and ...
    )
    [/code]

    If you'd be more specific I might be able to give you a better example.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

    [code]
    $ select * from users where clue > 0
    no rows returned
    [/code]

Sign In or Register to comment.