Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #15570

Re: sql with 3 tables

Show all headers | View raw

alex wrote:

> UPDATE a
> SET a.total = 33
> FROM  tabA AS a, tabC AS c
> WHERE a.id = c.id
> 
> warning: syntax error in the query SQL near at 'FROM tabA AS a, tabC AS
> c WHERE a.id = c.id' line 3 query: UPDATE a SET a.total = 33 FROM tabA
> AS a, tabC AS c WHERE a.id = c.id

RTFM.  But if your English was better, you would already realize that the 
sentence “UPDATE … *FROM* …” does not make sense (SQL is intentionally 
designed to resemble English).

It should be obvious that (My)SQL as such is off-topic here in 
comp.lang.*php*.

You also want to get a real name and an e-mail address.

-- 
PointedEars
Zend Certified PHP Engineer
Twitter: @PointedEars2
Please do not cc me. / Bitte keine Kopien per E-Mail.

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

sql with 3 tables alex <alex@nomailno.it> - 2015-07-05 11:49 +0200
  Re: sql with 3 tables adam <adam@nospam.net> - 2015-07-05 10:14 +0000
    Re: sql with 3 tables alex <alex@nomailno.it> - 2015-07-05 12:36 +0200
      Re: sql with 3 tables Luuk <luuk@invalid.lan> - 2015-07-05 19:06 +0200
    Re: sql with 3 tables alex <alex@nomailno.it> - 2015-07-05 16:41 +0200
      Re: sql with 3 tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-07-05 11:18 -0400
      Re: sql with 3 tables adam <adam@nospam.net> - 2015-07-05 17:14 +0000
      Re: sql with 3 tables adam <adam@nospam.net> - 2015-07-05 17:28 +0000
        Re: sql with 3 tables alex <alex@nomailno.it> - 2015-07-14 11:07 +0200
      Re: sql with 3 tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-07-06 03:28 +0200
    Re: sql with 3 tables alex <alex@nomailno.it> - 2015-07-05 18:07 +0200

csiph-web