>Hi All,
> I need to query data from a sql server call STG and the database call GM and table Parts. I need to run this query from a sql server call PRD. Thus, my query needs to be something like the following:
>
>Select * from STG.dbo.GM.Parts (from PRD server). However, I am not able to run this quey. Can someone help me out.
>
>Thanks

You need to add a linked server to STG server in PRD server.
After that you could runt this:

Select * from STG.GM.dbo.Parts

Did you see the difference?
The format is
[Server name].[DataBase name].[schema name].[table name]