Dieter Menne comments

Results 76 comments of


                                            Dieter Menne

exclude.fields not honoured

I just checked, and it is not exactly what I wanted, because it uses the tidyverse. Since I put 80% of my work to maintain 3 CRAN package on changing...

Multiple left joins fails in MS Access

This is a working version of SQL closest to dplyr's syntax. Use ___ instead of ..., and change the opening bracket to the location after FROM. See also [SO](https://stackoverflow.com/a/11526803/229794) ```...

Multiple left joins fails in MS Access

For a realistic example, see the `testdb.zip` Access file I included.

Multiple left joins fails in MS Access

``` library(odbc) library(dplyr) con = dbConnect(odbc::odbc(), .connection_string = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=./testdb.accdb") a = tbl(con, "a") b = tbl(con, "b") c = tbl(con, "c") # Works a |> left_join(b)...

Multiple left joins fails in MS Access

https://stackoverflow.com/a/20957480/229794

Re-licensing shiny as MIT

I agree