Error 1066 (42000) Not unique table/alias

Databases
1

I’ve found other refs to the Error 1066, but none that seem to address the issue I’m having.
(I am running MySQL server version 5.0.22)

The “SELECT” version of the query works as expected:

SELECT SnippetRating., Snippet_Raters., SnippetComments.*, SNIPPETS. * FROM (SNIPPETS LEFT JOIN SnippetRating ON SNIPPETS.ID = SnippetRating.Snippet_ID) LEFT JOIN SnippetComments ON SNIPPETS.ID = SnippetComments.Snippet_ID LEFT JOIN Snippet_Raters ON SNIPPETS.ID = Snippet_Raters.Snippet_ID AND Snippet_Raters.Snippet_ID = SNIPPETS.ID WHERE SNIPPETS.ID = 34;

However, the “DELETE” version (below) gives ERROR 1066 (42000): Not Unique table/alias: ‘SnippetRating’


DELETE SnippetRating., Snippet_Raters., SnippetComments.*, SNIPPETS. * FROM SnippetRating, Snippet_Raters, SnippetComments, SNIPPETS LEFT JOIN SnippetRating ON SNIPPETS.ID = SnippetRating.Snippet_ID) LEFT JOIN SnippetComments ON SNIPPETS.ID = SnippetComments.Snippet_ID LEFT JOIN Snippet_Raters ON SNIPPETS.ID = Snippet_Raters.Snippet_ID AND Snippet_Raters.Snippet_ID = SNIPPETS.ID WHERE SNIPPETS.ID = 34;

Any idea what could be going wrong in the DELETE version? (I’m scratching my head!)

Thanks,

Charlie

2

You’re using SnippetRating twice…

FROM SnippetRating, Snippet_Raters, SnippetComments, SNIPPETS LEFT JOIN SnippetRating

3

Ack – that’s it!

Thanks so much!