[drupal-devel] Mysql problem

[Gerhard Killesreiter]

On Thu, 12 May 2005, Gordon Heydon wrote:

> db_query('UPDATE {ec_ad_team} at LEFT JOIN {ec_transaction} t ON
> at.txnid = t.txnid SET at.did = %d WHERE t.workflow = %d and at.did =
> 0', $did, 6);
>
> The problem is that for some reason the on my clients mysql server
> doesn't seem to do the update, can anyone give me a reason why this
> would be happening, and a possible method of resolving this.

UPDATE does not support JOINs according to the mysql manual.

Cheers,
	Gerhard