|
#Outfits.Name# |
SELECT [Category].[Name], [ProductList].[ID], [ProductList].[SKU], [ProductList].[ProductName], [ProductList].[Description], [ProductList].[Quantity], [ProductList].[Size], [ProductList].[Price], [ProductList].[Active], [ProductList].[CategoryID], [ProductList].[Color]
FROM Category INNER JOIN ProductList ON [Category].[CategoryID] =[ProductList].[CategoryID]
where ProductList.OutfitID = #Outfits.OutfitID# and ProductList.Active = 1 and ProductList.Outfit = 1
|
BUY WHOLE OUTFIT |
|
|