1. Engineering
  2. Computer Science
  3. write an sql statement to produce a single column called...

Question: write an sql statement to produce a single column called...

Question details

Write an SQL statement to produce a single column called ItemLoactaion that combines the SKU_Description, the phrase “is located in”, and WarehouseCity.

The answer I came up with is:

SELECT SKU_Description + 'is located in' + WarehouseCity
AS ITEM_Location
FROM INVENTORY, WAREHOUSE
WHERE INVENTORY.WarehouseID=WAREHOUSE.WarehouseID;

But the results are returning just 0. Please help/ Thank you.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution