All pastes #627157 Raw Edit

Stuff

public sql v1 · immutable
·published 2007-07-20 03:44 UTC
rendered paste body
DROP VIEW TEST1GOCREATE VIEW TEST1ASSELECT	DrawingId, InternalDrawingNumberFROM	Drawing	GODROP VIEW TEST2GOCREATE VIEW TEST2ASSELECT ParentDrawingId, InternalDrawingNumberFROM DrawingWHERE	ParentDrawingId IS NOT NULLGODROP VIEW TEST3GOCREATE VIEW TEST3 ASSELECT	T1.InternalDrawingNumber, T2.ParentDrawingIdFROM	TEST1 T1, TEST2 T2WHERE	T1.DrawingId = T2.ParentDrawingId