List:General Discussion« Previous MessageNext Message »
From:Albert E. Whale Date:May 2 2008 8:05pm
Subject:Update with select
View as plain text  
I am trying to update a field on a record in a table.  Here is the 
statement I created:

UPDATE pdata SET pvalue = ( SELECT pvalue
FROM pdata
WHERE pentrytime =1207022400 )
WHERE pentrytime =1175400000;

However, I get the following error:

|#1093 - You can't specify target table 'pdata' for update in FROM clause

What can I use to fix this?
Albert E. Whale, CHS CISA CISSP
Sr. Security, Network, Risk Assessment and Systems Consultant
ABS Computer Technology, Inc. <> - Email, 
Internet and Security Consultants
SPAMZapper <> - 
<> - *True Spam Elimination*.
Update with selectAlbert E. Whale2 May
  • RE: Update with selectRolando Edwards2 May
    • Re: Update with selectRob Wultsch2 May