Re: Invalid Query?

[Paul DuBois]

At 11:12 AM -0700 9/27/01, Marci Wilken wrote:
>I was attempting the following query"
>
>Update trans set
>    tr_status = 'P'
>where invoice in (select invoice from tr_invoice
>                               where cls_num = 43)
>Is this not supported in Mysql?  I have used this in several
>other databases fine.  Or am I missing something in the
>format of query?
>
>Help is always appreciated
>Marci

You cannot update a table based on the contents of a related table.
Perhaps in MySQL 4.1.

-- 
Paul DuBois, paul@stripped