update select statement

[Patrick Bierans]

Wie kann ich diese 3 Statements verbinden?

1. select aic.price from TBL_AIC as aic where aic.cid=$CID

2. select pip.price from TBL_PIP as pip where pip.pool=$CID
   and pip.uid=$UID

3. update TBL_PIP as pip set pip.raised=(aic.price>pip.price) 
   where pip.uid=$UID and pip.pool=$CID

DIV
(Danke im Voraus)


---
Patrick Bierans

---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql