Devart Forums

Hi,
I have problem with DevArt ODBC driver ofr MongoDB.
MongoDB ver 3.2
MS Excel
DevArt ODBC driver trial version

When i use Microsoft Query to build my sql (in MS Excel), it will return data only when i do not put any WHERE clause.

SELECT customer.account_id, customer.name, order.account_id, order.billing_id
FROM myDB.customer customer, myDB.order order

which will return all rows from both tables

But when i put WHERE clause:

SELECT customer.account_id, customer.name, order.account_id, order.billing_id
FROM myDB.customer customer, myDB.order order
WHERE customer.account_id = order.account_id

it will return empty rows although they have data with same account_id (both have account_id of 1,2,3)

WHERE customer.account_id = 1 also not working

Thanks in advance

Thank you for the information.

We reproduced the issue and fixed it. This fix will be included in the next driver release. If you want to get this fix before the official release, please use the contact form at our site: https://www.devart.com/company/contactform.html and let us know that you need a trial of Devart ODBC driver for MongoDB. And we will send a night build to your email.