1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

sql query to combine credits tables

Discussion in 'Resource and Add-on Discussions' started by topcat, Sep 6, 2013.

  1. topcat

    topcat Well-Known Member

    Been using a couple of tables for credits.

    sportsbook and credits.

    I want to just use sportsbook and need to add the values from credits to the sportsbook table

    what sql query can I use to add field a to field b

    cheers
     
  2. topcat

    topcat Well-Known Member

    never mind done it

    UPDATE xf_user SET sportsbook_cash = sportsbook_cash + credits
     
    Last edited by a moderator: Sep 8, 2013

Share This Page