ShelbyW

In SQL Server, I'm constructing the view shown below. create view View_CAM as SELECT '5' FUNCTION, getdate() UPLOAD_DATE, 'U' STATUS, NULL INITIATED_DATE, NULL PROCESSED_DATE, NULL FINACLE_CUST_ID, NULL PROCESSING_USER_ID, **select currency from table_name** CURRENCIES For the CURRENCIES column, I must create a select query in order for the data to be shown. Above one is incorrect. how it can be accomplished Thank you in advance.