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

Groups > comp.lang.php > #15583

Re: sql with 3 tables

Show all headers | View raw

Il 05/07/2015 19:28, adam ha scritto:
> UPDATE
>      a AS a
> INNER JOIN
>      c AS c
>      ON (c.id = a.ic)
> INNER JOIN
>      b AS b
>      ON (b.id = c.id AND b.x < c.y)
> SET
>      a.totale = a.aa + c.bb

hello
your soution is this
UPDATE a AS a
INNER JOIN c AS c  ON (c.id = a.ic)
INNER JOIN b AS b  ON (b.id = c.id AND b.x < c.y)
SET  a.totale = a.aa + c.bb


I founded and tested and work, this
UPDATE a AS a
INNER JOIN c AS c  ON a.id = c.ic
INNER JOIN b AS b  ON c.id = b.id
SET  a.totale = a.aa + c.bb
WHERE b.x < c.y


your solution is the same?
is more performance seen that the where you use directky in the join?

is always better use after ON () the brackets?


thank

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