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

Groups > comp.lang.php > #15564

Re: sql with 3 tables

From alex <alex@nomailno.it>
Newsgroups comp.lang.php
Subject Re: sql with 3 tables
Date 2015-07-05 16:41 +0200
Organization Aioe.org NNTP Server
Message-ID <mnbfn9$8vo$1@speranza.aioe.org> (permalink)
References <mnauin$3lj$1@speranza.aioe.org> <5s7mx.1583$sG4.1199@fx25.fr7>

Show all headers | View raw

> UPDATE
>      a
> SET
>      a.totale = a.aa + c.bb
> FROM
>      a AS a,
>      b AS b,
>      c AS c
> WHERE
>      a.id = c.id
>      AND c.id = b.id
>      AND b.x < c.y
>


I tested but not work syntax error

also this (more simple not work for syntass error)
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

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