Restaurant POS : POSmen
 
Search this site

A Sample View

USE [POSmen]
GO

/****** Object:  View [dbo].[vMenus]    Script Date: 06/19/2009 23:17:30 ******/

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER VIEW vMenusHTML
AS

SELECT MenuGroup.AliasID AS [Menu Group], Menu.Name2 AS [Menu Name],
                Menu.Description AS Korean, Menu.Price
FROM Menu INNER JOIN MenuGroup
ON  Menu.MenuGroup = MenuGroup.MenuGroup
WHERE Name2 IS NOT NULL AND Price > 0
ORDER BY MenuGroup.MenuGroup, Menu.MenuID