SELECT Lot.lotID, Lot.lotName, Lot.lotOpeningBid, Lot.lotCloseDateTime, Category.categoryName FROM Lot INNER JOIN Category ON Lot.categoryID = Category.categoryID WHERE Lot.lotStatus = 'Open' AND Lot.lotPublic = 1 ORDER BY Lot.lotName #getAllLots.lotName##LSCurrencyFormat(lotOpeningBid,"local")##categoryName##LSDateFormat(lotCloseDateTime,"MM/DD")#