RazorEddie
Technical User
I'm trying to run a query against a DB I can't see, back end for a program. I have access to a access sample db that should be identical in structure.
SELECT [TDS Loans].Account AS LoanRecID
FROM [TDS Loans] INNER JOIN [TDS Charges] ON [TDS Loans].RecID = [TDS Charges].ParentRecID
WHERE [TDS Charges].Description="NSF";
Works in Access, but against the SQL Version gives me the following:
"The Query Failed to Execute Properly,
Unable to populate Table,
Unable to open Data Table,
Invalid column Name 'NSF'
I have had version that execute properly but return 0 rows which is not accurate.
This for example:
SELECT [TDS Loans].Account AS LoanRecID
FROM [TDS Loans] INNER JOIN [TDS Charges] ON [TDS Loans].RecID = [TDS Charges].ParentRecID
WHERE [TDS Charges].OwedToBal=$35.00
I know there is at least one record with that value in both DB's, in Access it returns the one row but not SQL.
Can any one point me in the right direction?
SELECT [TDS Loans].Account AS LoanRecID
FROM [TDS Loans] INNER JOIN [TDS Charges] ON [TDS Loans].RecID = [TDS Charges].ParentRecID
WHERE [TDS Charges].Description="NSF";
Works in Access, but against the SQL Version gives me the following:
"The Query Failed to Execute Properly,
Unable to populate Table,
Unable to open Data Table,
Invalid column Name 'NSF'
I have had version that execute properly but return 0 rows which is not accurate.
This for example:
SELECT [TDS Loans].Account AS LoanRecID
FROM [TDS Loans] INNER JOIN [TDS Charges] ON [TDS Loans].RecID = [TDS Charges].ParentRecID
WHERE [TDS Charges].OwedToBal=$35.00
I know there is at least one record with that value in both DB's, in Access it returns the one row but not SQL.
Can any one point me in the right direction?