On 12 Mar 2013, at 9:12pm, ven...@intouchmi.com wrote: > The first select was the one that I retrieved from the MS Access DB. That > one does NOT work in SQLite. Thanks for explaining why it wasn't acceptable > by SQLite.
You're welcome. > It was the second select, which I rewrote, that I was asking about. That one > is acceptable by SQLite. My question was if the second one accomplished the > same end results as the original (first) select. We don't know because on this mailing list we understand SQLite but not especially MS Access. You would need to ask on an Access mailing list what Access would do for such a query. Or you could read the Access documentation yourself. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
