Forum Discussion
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-...
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.
- I see, thanks for the help!
