MySQL 1066: Not unique table/alias error even though I have defined table alias

Question

My Sql query is

Select a.sum_total FROM
OneWayNetTransactionRes a
LEFT OUTER JOIN
OneWayNetTransactionRes b
ON
a,frm_id = b.to_id
AND a.to_id = b.frm_id

Where OneWayNetTransactionRes is a view.

CREATE VIEW `OneWayNetTransactionRes` AS
SELECT frm_id, to_id, sum(amount) total_amount
FROM TransactionResolution
GROUP BY frm_id, to_id

Yet I get the error

1066: Not unique table/alias: 'b'

juergen d · Accepted Answer · 2012-06-03 15:17:34Z

2

Use a . instead of ,:

ON a.frm_id = b.to_id

instead of

ON a,frm_id = b.to_id

answered Jun 3, 2012 at 15:17

juergen d

205k40 gold badges304 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1