Posted By: snake (keeping on the sunny side) on 'CZdatabases'
Title:     Re: SQL
Date:      Fri Sep 21 11:01:37 2001

> UPDATE
>   members
> SET
>   purchased = 'y'
>   WHERE
>     members.id = purchased.id_user;
> ERROR 1109: Unknown table 'purchased' in where clause
> /* A co ted ? :o/ */

WHERE
  members.id IN (SELECT id FROM blablabla WHERE blabla)

snake