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

Groups > comp.lang.php > #15570

Re: sql with 3 tables

Path csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!1.eu.feeder.erje.net!newsfeed.datemas.de!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From Thomas 'PointedEars' Lahn <PointedEars@web.de>
Newsgroups comp.lang.php
Subject Re: sql with 3 tables
Date Mon, 06 Jul 2015 03:28:05 +0200
Organization PointedEars Software (PES)
Lines 25
Message-ID <84483321.KXZHGnSGLH@PointedEars.de> (permalink)
References <mnauin$3lj$1@speranza.aioe.org> <5s7mx.1583$sG4.1199@fx25.fr7> <mnbfn9$8vo$1@speranza.aioe.org>
Reply-To Thomas 'PointedEars' Lahn <php@PointedEars.de>
Mime-Version 1.0
Content-Type text/plain; charset="UTF-8"
Content-Transfer-Encoding 8Bit
X-Trace solani.org 1436146270 11371 eJwFwYEBACAEBMCVkjzGkc/+I3RnCkH7geHY2JTrWwblDS82pk5NpueWvTiM1hRmybMb1P4m6BGc (6 Jul 2015 01:31:10 GMT)
X-Complaints-To abuse@news.solani.org
NNTP-Posting-Date Mon, 6 Jul 2015 01:31:10 +0000 (UTC)
User-Agent KNode/4.14.2
X-User-ID eJwVx8ERwDAIA7CV6mAcGCeFsP8IveonN0G1KRd9fJ5/x4DOHBgSh6G7evvc6DcAuyQzU5XZYtGOY4WmSvwALzUUjQ==
Cancel-Lock sha1:/NFDx4ye5atfu6orKbYUBZL85Kc=
X-NNTP-Posting-Host eJwNx8kRwDAIBLCWwGYXUw7D0X8JiX7CpbLcCBoWuzYCTtYck3xh0y2t1Ir/I8OXHkTw+kmrDyVNEQQ=
Xref csiph.com comp.lang.php:15570

Show key headers only | 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