Jump to content

lemarsu

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

lemarsu's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I have written some SQL but it would not work under mysql (in the office DB2 and oracle are ok with this kind of sql) the following sql is what I am trying to run : UPDATE tableA, tableB SET tableA.usergroupid=8 WHERE tableB.userid= tableA.userid AND tableB.country= \'United Kingdom\' AND tableA.usergroupid=\'5\' Can anyone please help.... Thanks LeMarsu
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.