Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    46

    Unanswered: Pass-Through Query - What is wrong?

    Hi All,

    Trying to create a pass-through query. My statement is:

    SELECT IDENTIFIERS.ORGID, IDENTIFIERS.ISIN_CODE, PUBLIC2.RATINGTYPE, PUBLIC2.RATING, PUBLIC2.RATINGDATE FROM IDENTIFIERS INNER JOIN PUBLIC2 ON IDENTIFIERS.ORGID = PUBLIC2.ORGID

    The error message that comes back is SQL Command not properly ended.

    I have tried adding ; at the end but with the same result.

    Any ideas?

  2. #2
    Join Date
    Jun 2002
    Location
    Vienna, VA
    Posts
    53
    SQL server may not do the inner join stuff the same way Access does. Change the InnerJoin stuff to:

    From IDENTIFIERS, PUBLIC2
    Where IDENTIFIERS.ORGID = PUBLIC2.ORGID



    Leah

  3. #3
    Join Date
    Mar 2003
    Posts
    46
    Hi Leah,

    worked a treat, thanks!

    C

Posting Permissions

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