PRODUCT SEARCH
Enter Keyword..
QUICK SELECTOR
Price Range
Catagory
Country

HOME 

FEATURED WINES

TASTING EVENTS

FIND A WINE

VIEW QUOTE

BORDEAUX

SERVICES

RESOURCES

INDUSTRY LINKS

CONTACT US

 

BRITANNIA WINE MERCHANTS
Find A Wine

 
strSQL2=SELECT INVHDR.ICLASS, ICLASS.DESCRIPTION, Count(INVHDR.ICLASS) AS CountOfIClass FROM INVHDR INNER JOIN ICLASS ON INVHDR.ICLASS = ICLASS.ICLASS WHERE INVHDR.WEBSALE=1 AND INVHDR.CATAGORY='WINE' GROUP BY INVHDR.ICLASS, ICLASS.DESCRIPTION ORDER BY ICLASS.DESCRIPTION
Wine (1266)