Create a view on another DB

Hello !

I have a "SQLServer Express" database andI would like to create a view in it, pointing to data from another database (Progress)

Is this possible ? How ?

Thanks,

Ok I succeed using the linked servers.

However I have read that we could use the syntax

select * from linked_server_name..schema.table

but this gives me an error. It's ok when I use :

select * from OPENQUERY(linked_server_name, 'select * from schema.table')

I cannot use the first syntax ?