Having an issue in inner join querie not unique alias table

I was basically trying to run my queries, I had no trouble with syntax but as soon as I try to run it, I get the following.

Select happy.customer_num

From happy

inner Join happy On Happy.Customer_num = Account.Customer_num Where Account.Account_Num = "";

*Error Code: 1066. Not unique table/alias: 'happy'

Does any body understand this issue, any help would be greatly appreciated****

https://stackoverflow.com/questions/67377572/having-an-issue-in-inner-join-querie-not-unique-alias-table May 04, 2021 at 09:08AM