Would it be possible to give a table in MySQL query multiple aliases?
If so how would I do this?
You can if you are using the table multiple times in different clauses and/or sub-queries like
But you can not give the same use of a table more than one alias - the following for instance is invalid syntax:
Also, you can not (in most DBMSs) use a table by both its real name and alias, so the following is invalid too:
If ause of an object is given an alias you must refer to that instance by that alias even if the real name is unambiguous within the query.
Yes you can.
For example: for a table such as this:
You can query it like so :