View: dbo.Magnetic_Media_File_View | |||
View definition | |||
-- Create the Magnetic Media Files View CREATE VIEW dbo.Magnetic_Media_File_View AS SELECT MMF.magnetic_media_file_KEY , MMF.period_end_date , MMF.magnetic_media_file_status_KEY , MMF.creation_date , MMF.last_modified , MMF.tax_form_KEY , MMF.staff_KEY , MMF.magnetic_media_file_guid , CONVERT(INT, TF.ste_state_code_KEY) AS state_KEY -- table doesn't allow null so don't worry about it here. , MMF.is_corrected , MMF.batch_number , MMF.separate_client_files FROM dbo.Magnetic_Media_File AS MMF INNER JOIN dbo.Tax_Form AS TF ON TF.tax_form_KEY = MMF.tax_form_KEY; | |||