Table 'T_NAME' is specified twice, both as a target for 'INSERT' and as a separate source for data

  SELECT IFNULL(MAX(ORDER_NO), 0) + 1

      FROM T_NAME ALIAS_FOR_SUBQUERY

 

ALIAS_FOR_SUBQUERY  <- 이거 추가해주면 된다.