SELECT * FROM Products WHERE Products.ItemID > 1 SELECT * FROM Categories WHERE Category <> 'Dummy' SELECT * FROM Products WHERE ItemID > 1 SELECT Products.*,Categories.*,ProdPics.* FROM ProdPics RIGHT JOIN (Categories INNER JOIN Products ON Products.CategoryID = Categories.CategoryID) ON Products.ItemID = ProdPics.ItemID WHERE Products.CategoryID = WHERE Products.SubCatID = AND Products.SubCatID = 0 WHERE Products.SubCatID = ORDER BY Products.CategoryID,Products.ItemName SELECT * FROM Categories WHERE EXISTS (SELECT Products.*,Categories.* FROM Products INNER JOIN Categories on Products.CategoryID = Categories.CategoryID) ORDER BY Categories.Category Blue Crab Clothing


Click on a category from the menu on the left to see
our wide selection of products and great prices!

ALL CATEGORIES
SELECT * FROM SubCats WHERE TopCatID = ORDER BY SubCat
#prodpage.Category#


#ItemName#
#find_subcats.SubCat#

SELECT SubCat FROM SubCats WHERE SubCatID =
#getsubcats.SubCat#


#ItemName#
  #Description#
#ItemName#
Price Qty Weight   
#TRIM(NumberFormat(Price,"$999,999,999.99"))# #NumberFormat(Weight,"____.__")# Ounces