Views are created in SQL Server.

[kulluM]

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. The above one is incorrect. how it can be accomplished
Thank you in advance.

 

[pix07]

@kulluM What kind of database ?

MySQL,NoSQL or oracle SQL ?

 

[Robert]

He said SQL Server - it's Microsoft's multi-user business product.
You won't be able to answer his question without more information.