DROP VIEW TEST1
GO
CREATE VIEW TEST1
AS
SELECT	DrawingId, InternalDrawingNumber
FROM	Drawing	
GO

DROP VIEW TEST2
GO
CREATE VIEW TEST2
AS
SELECT ParentDrawingId, InternalDrawingNumber
FROM Drawing
WHERE	ParentDrawingId IS NOT NULL
GO

DROP VIEW TEST3
GO
CREATE VIEW TEST3 AS
SELECT	T1.InternalDrawingNumber, T2.ParentDrawingId
FROM	TEST1 T1, TEST2 T2
WHERE	T1.DrawingId = T2.ParentDrawingId