Forum Discussion
ErenC1585
Apr 07, 2024Copper Contributor
Confused in aliasing
SELECT Warehouse.warehouse_id, CONCAT (Warehouse.state,":", Warehouse.warehouse_alias) AS warehouse_name, COUNT (Orders.order_id) AS num_of_orders, (SELECT COUNT(*) FROM resonant-apex-...
olafhelper
Apr 08, 2024Bronze Contributor
ErenC1585 to just Orders because of my alias on line 19, will this sql work?
No, you can not use a alias within the same SQL statement.
- ErenC1585Apr 08, 2024Copper ContributorI see, thanks for the help!