Devart Forums

I am trying to either update a table or delete records based on an inner join or a where. I have tried several different ways to do this. To test I was getting the records I wanted, I did a select query. It works perfectly. When I change the query to either a delete or an update, I get an "unknown table" error. I have attached an image of my screen. I have also tried this as an inner join and still get the "unknown table" error. Any help is appreciated.

https://app.box.com/s/4l51nfhzu8smogo7sdmyam00f2mgbdvb

Hello,

Thanks for the post.

1) Please write USE you_database before UPDATE like the following: 2) Try to run the following script to invoke information about the table: 3) Could you provide server version by executing the following statement: Best Regards.

I added the use wordscrubbertest before the update and am still getting the error.

Results for show create table aoswords are:

https://app.box.com/s/d0u0b9qibbcoyghxs0xy8wq1ws0a5jkx

Version is 5.6.21

Thanks.

Hello,

Sorry for the delay.
Thanks for the information, but you provide a log from the Output window. Could you please provide a result from the data editor window. Please have a look at the following screenshot:



Also try to execute the following query: then try to execute: Best Regards.