Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Exclamation Unanswered: 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?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: Remote Join SQL7

    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/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •