sql query to combine credits tables

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
 

topcat

Well-known member
never mind done it

UPDATE xf_user SET sportsbook_cash = sportsbook_cash + credits
 
Last edited by a moderator:
Top