Ah, thanks.

That example straightened out the logic of aliasing the tables a bit better in my head.

The problem I have now run into is that it wants me to add...

Here ya go:

IF EXISTS (SELECT TABLE_NAME

FROM INFORMATION_SCHEMA.VIEWS

WHERE TABLE_NAME = 'SMC_Test')

DROP VIEW SMC_Test

GO

CREATE VIEW SMC_Test

AS

SELECT...