Error: Every derived table must have its own alias

Knowledge Drop

Last tested: Aug 17, 2020
 

This is a MySQL error that gets triggered if two PDTs are named the same.

If you've checked no PDTs share a name, check the dt sql for missing parentheses/brackets - not closing the parentheses can also throw this error.

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 01:12 PM
Updated by: