List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 27 2001 6:31pm
Subject:Re: Invalid Query?
View as plain text  
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
Thread
Invalid Query?Marci Wilken27 Sep
  • Re: Invalid Query?Paul DuBois27 Sep
  • Re: Invalid Query?Chris27 Sep
  • Re: Invalid Query?Tim Wilde27 Sep
    • Post Installation QuestionIntekhab Choudhury27 Sep
      • Re: Post Installation QuestionIng. Gustavo Edelstein27 Sep
      • Re: Post Installation QuestionIntekhab Choudhury1 Oct
  • Re: Invalid Query?Carl Troein27 Sep
  • Re: Invalid Query?Sam Masiello27 Sep
  • Re: Invalid Query?Rodney Broom27 Sep
Re: Post Installation QuestionIng. Gustavo Edelstein28 Sep