sql with 3 tables

From	alex <alex@nomailno.it>
Newsgroups	comp.lang.php
Subject	sql with 3 tables
Date	2015-07-05 11:49 +0200
Organization	Aioe.org NNTP Server
Message-ID	<mnauin$3lj$1@speranza.aioe.org> (permalink)

Show all headers | View raw

in this condition between two tables A and C

UPDATE  A AS A
INNER JOIN C AS C
ON      A.id = C.id
SET     A.totale = A.aa + C.bb

I must to add another condition
respect at one table B


for to have this
UPDATE  A AS A
INNER JOIN C AS C
ON      A.id = C.id
SET     A.totale = A.aa + C.bb
---> WHERE (B.x < C.y WHERE B.id=C.id) <--



how?
thank

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