Using AS in JOIN's

  • Thread starter Thread starter John T Ingato
  • Start date Start date
J

John T Ingato

Scenario:
Table1 Stores: StoreNumber, Address, SKUNumber, InventoryLevel
Table2 Products: ItemNumber, Description, Size, ect.
Table3 Stores_Products: SKUNumber, ItemNumber

Is it possible to add "AS" to the following SQL
**************************************************************************WITHOUT
SELECT
Stores.StoreNumber,
Products.Description,
Stores.InventoryLevel
FROM (Stores INNER JOIN Stores_Products ON Stores.SKUNumber =
Stores_Products.SKUNumber)
INNER JOIN Products ON Stores_Products.ItemNumber = Products.ItemNumber

***************************************************************************WITH
"AS"
SELECT
Stores.StoreNumber,
Products.Description,
Stores.InventoryLevel
FROM (Stores INNER JOIN Stores_Products ON Stores.SKUNumber =
Stores_Products.SKUNumber) As Join1
INNER JOIN Products ON Join1.ItemNumber = Products.ItemNumber
 
I haven't seen that but perhaps, you should tell us the purpose and what you
are trying in details and others may be able to suggest alternatives.
 
Back
Top