SELECT * FROM mylinkedserver.yourcatalogname.mytable

EG:

select * from linkedservername.catalogname.tablename

Trend: Linked Server Name

CatalogName: BestData

Tablename:simons

select * from Trend.BestData.simons

Thanks,

Satish Kumar.