SELECT * FROM Venue, Category, MenuItem WHERE MenuItem.CategoryID = Category.CategoryID and MenuItem.VenueID = Venue.VenueID ORDER BY MenuItem.VenueID, MenuItem.CategoryID, MenuItem.MenuItem;
(Items prefixed with V are suitable for Vegetarians)
#Venue#
#VenueDesc#
#Category#
#CatDesc#
V  #MenuItem#
#ItemDesc#
£ #DecimalFormat(cost)#
#MenuSubItem#
#MenuItem#
#ItemDesc#
£ #DecimalFormat(cost)#
#MenuSubItem#