When using qualified column names in any query, the names may become very long. Use the AS keyword in the FROM clause to assign shorter aliases to data source names.
To assign shorter aliases to data source names, using the syntax FROM data-source AS alias. For example, the StockTrades and TradeInquiry data streams in the above example, may be given the alias ST and SI, respectively. The same query would then look like this:
INSERT INTO TradeResults SELECT S.* FROM TradeInquiry AS T, StockTrades AS S KEEP LAST WHERE T.symbol = S.symbol GROUP BY S.symbol;