select qmd_priceLists.priceListId, qmd_manufacturers.bidMfrId, qmd_priceLists.priceListCode, qmd_priceLists.priceListDesc, qmd_priceLists.priceListStartDate, qmd_priceLists.priceListEndDate, qmd_manufacturers.bidMfrName from qmd_priceLists, qmd_manufacturers where qmd_manufacturers.bidMfrId = qmd_priceLists.bidMfrId order by bidMfrName, priceListEndDate desc

Pricing Code	Start	End
#htmleditformat( bidMfrName )#
#htmleditformat( priceListCode )#	#lsdateformat( priceListStartDate, "MM/DD/YY")#	#lsdateformat( priceListEndDate, "MM/DD/YY")#

#_portletBodyHTML#