16 ms·
The moment you have the same table used more than once as a table source (in a JOIN) then this goes out the window. Moreover, there's nothing wrong with saying
by cryptonector 5y ago
The moment you have the same table used more than once as a table source (in a JOIN) then this goes out the window.
Moreover, there's nothing wrong with saying `SELECT ... FROM sales sales ...`.
- Orou 5y agoWholeheartedly agree with this. The problem isn't aliasing, it's lazy aliasing which is more I think what GP was referring to (e.g. emp.id instead of employee.id).