Can't seem to reach the next step in my update query. I'm able to successfully view columns related to the select no problem:

```
SELECT sales_flat_order_grid.entity_id,sales_flat_order_grid.increment_id,sales_flat_order.coupon_code
FROM sales_flat_order_grid 
INNER JOIN sales_flat_order ON sales_flat_order_grid.entity_id = sales_flat_order.entity_id     
WHERE sales_flat_order_grid.increment_id = "12345678";

```

This shows 3 columns all where related to the correct increment\_id.

The next step is to update the sales\_flat\_order.coupon\_code field. Here is my attempt:

```
UPDATE sales_flat_order 
INNER JOIN sales_flat_order ON sales_flat_order_grid.entity_id = sales_flat_order.entity_id      
WHERE sales_flat_order_grid.increment_id = "12345678"
SET coupon_code = "newcoupon";

```

But I keep getting a ***Not unique table/alias: 'sales\_flat\_order'*** error message. Could someone point me in the right direction?