Alias Table Name¶

The purpose of an alias table is to make two or more joins possible to the same set of data at the same time. For example, if your data (for example, a product) contains information about a vendor, a shipment company, and a warranty supplier, you could have all this information in a central table named addresses. The product that can be bought can then show information for vendor, shipment, and warranty companies in the same report row.

The result can then be:

Both entries point to the same table.