#1066 - 错误不是唯一的表别名

我正在学习 mysql，但我的其中一张表出现了问题，该表产生了 #1066 - 错误不是唯一的表别名.我尝试了许多不同的查询，但结果都相同.有人可以让我摆脱痛苦并帮助指出我做错了什么！- 谢谢

I am learning mysql and I am having trouble with one of my tables which produces #1066 - error not unique table alias. I have tried a number of different queries but all have the same result. Can someone put me out of my misery and help point out what I am doing wrong! - Thanks

表格

looks
---------

look_id(Pk)
user_id
title
description
date_modified

Add_Look_Item
-----------------------

look_id (fk from table 1)
item_id (fk from table 3)

Item
--------------

item_id (pk)
name
details

Add_Images
-------------------
image_id (pk)
item_id (fk from table 3)
image_name

我尝试过的查询 - add_look_item 是一个复合键

Queries I have tried - add_look_item is a compound key

SELECT DISTINCT looks.look_id, looks.title, looks.date_modified, add_look_item.item_id,     add_images.image_name FROM looks JOIN add_look_item ON add_look_item.look_id = looks.look_id
JOIN add_look_item ON add_look_item.item_id = item.item_id WHERE look.user_id = 94

#1066 - error not unique table alias 'add_look_item

SELECT DISTINCT looks.look_id, looks.title, looks.date_modified, add_look_item.item_id,     add_images.image_name FROM looks JOIN 
add_look_item ON add_look_item.looks_id = look.look_id
JOIN add_look_item ON add_look_item.item_id = item.item_id
JOIN add_images ON add_images.item_id = item.item_id WHERE add_look_item.item_id =    item.item_id AND look.user_id = 94

#1066 - error not unique table alias 'add_look_item

SELECT DISTINCT looks.look_id, looks.title, looks.date_modified, add_look_item.item_id,   add_images.image_name FROM looks INNER JOIN add_look_item ON add_look_item.look_id =    look_look_id
INNER JOIN add_images ON add_images.item_id = item.item_id
INNER JOIN add_look_item ON add_look_item.item_id = item.item_id
WHERE look.user_id = 94

#1066 - error not unique table alias 'add_look_item

SELECT DISTINCT looks.look_id, looks.title, looks.date_modified, add_look_item.item_id,    add_images.image_name FROM looks 
INNER JOIN add_look_item ON add_look_item.looks_id = look.look_id
INNER JOIN add_images ON add_images.item_id = item.item_id
INNER JOIN add_look_item ON add_look_item.item_id = item.item_id 
WHERE add_look_item.item_id = item.item_id AND look.user_id = 94


#1066 - error not unique table alias 'add_look_item

SELECT DISTINCT looks.look_id, looks.title, looks.date_modified, add_look_item.item_id,    add_images.image_name FROM looks 
INNER JOIN add_look_item ON add_look_item.looks_id = look.look_id
INNER JOIN add_images ON add_images.item_id = item.item_id
WHERE add_look_item.item_id = item.item_id AND look.user_id = 94

#1054 - Unknown column 'item.item_id' in 'where clause'

谢谢