Ida B Wells Total Post:30 Points:210 Posted by Ida B Wells July-09-2013 3:11 AM MYSQL MYSQL 1 Reply(s) 2378 View(s) Ratings: Rate this: Hi Expert! I can see why this is problematic, but can't seem to work out the fix like others here on SO have.. I wan't to increment the ticket number using a sub_query. Can't use auto_inc as already have an auto_inc'ing primary key.. Here's what i want to do: UPDATE tickets SET tickets.ticket_number=( SELECT (MAX(ticket_number)+1) FROM tickets ) WHERE ticket_id=12345; Gives me: You can't specify target table 'tickets' for update in FROM clause Thanks!