Remote Join SQL7

This functionality seem not work fine on this version of Ms SQL Server.

The syntax
SELECT *
FROM CATAL_MAG CATM
REMOTE JOIN
CATAL CAT
ON CATM.CODE_ART=CAT.CODE_ART
WHERE CATM.NO_MAG='100'
AND CATM.CODE_ART='MART'

This query give me error on some SQL7 Servers (yes not all configurations crash)

The error is :

Server: Msg 170, Level 15, State 1, Line 9
Line 9: Incorrect syntax near 'REMOTE'.

What is wrong on my configuration?Originally posted by Franck6
yes not all configurations crash


I could be wrong but I highly doubt it

I've never seen that syntax...

Look in BOL..it's not even there...

You sure you're talking about SQL Server...you know Redmond?

http://www.ci.redmond.wa.us/