Mine

DROP VIEW DrawingVWGOCREATE VIEW DrawingVW SELECT	D.ProjectId, D.DrawingId, 		D.InternalDrawingNumber, DT.DrawingTypeName, 		DR.DrawingRevisionNumber, D.ModuleId, DR.Date, D.ParentDrawingId, 		D.ParentRevisionNumber,		(SELECT	InternalDrawingNumber		 FROM	Drawing		 WHERE DrawingId = ParentDrawingId)FROM	Drawing D, DrawingRevision DR, DrawingType DTWHERE	D.DrawingId = DR.DrawingIdAND		D.DrawingTypeId = DT.DrawingTypeId-- TEST AREA::: trying to pull back values for drawings with parents onlySELECT	DrawingId, InternalDrawingNumber, ParentDrawingIdFROM	DrawingWHERE	DrawingId = (Select ParentDrawingId					FROM	Drawing					WHERE	ParentDrawingId = ())