USE WMS
GO

CREATE VIEW EmployeeVW
AS
	SELECT	E.EmployeeId, E.LastName, E.FirstName, EP.PositionName, E.Status
	FROM	Employee E, EmployeePosition EP
	WHERE	E.EmployeePositionId = EP.EmployeePositionId
		AND	E.EmployeePositionId <>	(Select EP.EmployeePositionId
									 FROM	EmployeePosition EP
									 WHERE	LOWER(EP.PositionName) = LOWER('Welder'))