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?
Thank you!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;