Re: sql with 3 tables

From	alex <alex@nomailno.it>
Newsgroups	comp.lang.php
Subject	Re: sql with 3 tables
Date	2015-07-05 18:07 +0200
Organization	Aioe.org NNTP Server
Message-ID	<mnbknq$k11$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
>

with double inner join is the solution?
so I haven't error
but must verified the result

UPDATE  a AS a
             INNER JOIN c AS c
             ON      a.id = c.id
             INNER JOIN b AS b
             ON      c.id = b.id
             SET     a.total = 33
             WHERE b.x < c.y

Back to comp.lang.php | Previous | Next — Previous 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