Results 1 to 9 of 9
  1. #1
    capjlp is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2014
    Location
    Berea, Ky
    Posts
    26

    Access Pass Through Query to a Oracle Database using a simple "simple" inner friken join.

    Hi



    I am trying to use a pass through query to get some data I have to set a where clause by date range but I can't get the first part of my query to work. I am trying to use Inner Join and I have tried a bunch of samples I have read on this forum and others but it keeps saying ODBC call failed. Invalid Character
    Blah Blah... I ran the select as pass through on both queries and get data from both tables separately.

    Here is my query what the heck am I doing wrong?

    Code:
    SELECT DSCI.METERACCTS.METERNUMBER,DCSI.METERACCTSMIT.METERMITREADDT, DCSI.METERACCTSMIT.METERMITDATA1 
    FROM DSCI.METERACCTS
    INNER JOIN DSCI.METERACCTSMIT ON DSCI.METERACCTS.SERIALNUMBER = DSCI.METERACCTSMIT.SERIALNUMBER;
    
    Thank you!

    Last edited by capjlp; 03-16-2016 at 08:26 AM.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,430
    Is there really a space here, or ?????
    CTSMIT.MET ERMITREADDT,
    ------------------^---------------------

  3. #3
    capjlp is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2014
    Location
    Berea, Ky
    Posts
    26
    Hey

    No its not I seen that also. I tried to edit and it doesn't show but when I save it does.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,195
    The forum software adds a space every 50 characters if there are none. You can use the Code tags to avoid that.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    capjlp is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2014
    Location
    Berea, Ky
    Posts
    26
    Ok Thnk you pbaldy. I added the code tags space is gone now. Does anyone know what's wrong with it now?

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,195
    I've never used Oracle, so not sure of its syntax. I suppose you can try without the semicolon. It's optional in Access.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,430
    I haven't used Oracle for a number of years. I don't think there is an issue with the ";".
    It could be related to the DSCI.????just a guess - since I don't ever recall a table with . in the name or 2 levels of qualification????

    When using a pass through query, the SQL syntax must be that of the target database.

  8. #8
    capjlp is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2014
    Location
    Berea, Ky
    Posts
    26
    Quote Originally Posted by orange View Post
    I haven't used Oracle for a number of years. I don't think there is an issue with the ";".
    It could be related to the DSCI.????just a guess - since I don't ever recall a table with . in the name or 2 levels of qualification????

    When using a pass through query, the SQL syntax must be that of the target database.
    I tried with out. The DSCI. does work in select with just one table.

  9. #9
    capjlp is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2014
    Location
    Berea, Ky
    Posts
    26
    Quote Originally Posted by capjlp View Post
    Hi

    I am trying to use a pass through query to get some data I have to set a where clause by date range but I can't get the first part of my query to work. I am trying to use Inner Join and I have tried a bunch of samples I have read on this forum and others but it keeps saying ODBC call failed. Invalid Character
    Blah Blah... I ran the select as pass through on both queries and get data from both tables separately.

    Here is my query what the heck am I doing wrong?

    Code:
    SELECT DSCI.METERACCTS.METERNUMBER,DCSI.METERACCTSMIT.METERMITREADDT, DCSI.METERACCTSMIT.METERMITDATA1 
    FROM DSCI.METERACCTS
    INNER JOIN DSCI.METERACCTSMIT ON DSCI.METERACCTS.SERIALNUMBER = DSCI.METERACCTSMIT.SERIALNUMBER;
    
    Thank you!

    Too Simple... didn't need the inner join... ARGH!!!!!!!!

    Just used Where... Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 03-14-2016, 05:10 AM
  2. Replies: 18
    Last Post: 11-04-2015, 02:13 PM
  3. Replies: 5
    Last Post: 05-28-2015, 03:27 PM
  4. simple "between dates" query
    By mejia.j88 in forum Queries
    Replies: 4
    Last Post: 02-06-2012, 06:22 PM
  5. a simple "display date " query
    By Ushera in forum Queries
    Replies: 2
    Last Post: 07-31-2009, 06:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums