quote:

---

Originally posted by dr223

Microsoft SQL Server 2005 managament studio..

jayam tried your suggestion and received the follwing error;

Msg 7202, Level 11, State 2, Line 1
Could not find server 'GPFGSCSF01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

Any help please!!!

Many thanks

---

EXEC sp_addlinkedserver
'GPFGSCSF01',
N'SQL Server'
GO

SELECT gprdsql.TblPracDetails.prac_no, [GPRC-RCT].dbo.Practice.PracNo AS Expr1
FROM gprdsql.TblPracDetails INNER JOIN
[GPFGSCSF01].[GPRC-RCT].dbo.Practice ON gprdsql.TblPracDetails.prac_no = [GPRC-RCT].dbo.Practice.PracNo

GO

SELECT 
    gprdsql.TblPracDetails.prac_no, 
    Practice.PracNo AS Expr1
FROM 
    gprdsql.TblPracDetails 
INNER JOIN
    [GPFGSCSF01].[GPRC-RCT].dbo.Practice AS Practice
    ON gprdsql.TblPracDetails.prac_no = Practice.PracNo

SELECT DISTINCT TOP (100) PERCENT dbo.TblAuto_coll.Prac_no
FROM         dbo.TblAuto_coll INNER JOIN
             [GPFGSCSF01].[GPRD-RCT].dbo.Practice ON dbo.TblAuto_coll.Prac_no = [GPFGSCSF01].[GPRD-RCT].dbo.Practice.PracNo
ORDER BY dbo.TblAuto_coll.Prac_no

quote:

---

Originally posted by dr223

Thanks Lamprey .. It worked, what if i have the following query instead how can i create the table alias..

SELECT DISTINCT TOP (100) PERCENT t1.Prac_no
FROM         dbo.TblAuto_coll t1 INNER JOIN
             [GPFGSCSF01].[GPRD-RCT].dbo.Practice t2 ON t1.Prac_no = t2.PracNo
ORDER BY t1.Prac_no

---