Hi All!
I just discovered sqldf and im very enthousiastic, as I am a big fan of
R and I often get frustrated using Access for datamanagement.
I tried running some queries from Access in R, and it works very well.
However, I have problems with some queries.
If I run this SQL query:
Marvelde, Luc te l.temarve...@nioo.knaw.nl writes:
If I run this SQL query:
sqldf(SELECT
+ dbo_tbl_Terrein.RingCentraleNaam,
+ dbo_tbl_Broedsels.BroedselID
+ FROM ((dbo_tbl_BroedselLocatie
+ INNER JOIN dbo_tbl_Broedsels ON dbo_tbl_BroedselLocatie.BroedselID =
dbo_tbl_Broedsels.BroedselID)
2009/11/20 Tom Lane t...@sss.pgh.pa.us:
Marvelde, Luc te l.temarve...@nioo.knaw.nl writes:
If I run this SQL query:
sqldf(SELECT
+ dbo_tbl_Terrein.RingCentraleNaam,
+ dbo_tbl_Broedsels.BroedselID
+ FROM ((dbo_tbl_BroedselLocatie
+ INNER JOIN dbo_tbl_Broedsels ON
Hello
2009/11/20 Marvelde, Luc te l.temarve...@nioo.knaw.nl:
Hi All!
I just discovered sqldf and im very enthousiastic, as I am a big fan of R
and I often get frustrated using Access for datamanagement.
I tried running some queries from Access in R, and it works very well.
However, I have
Nothing is wrong with the data... Everything is there in the dataframe. All the
names are case sensitive, but the way it is spelled is correct So that cant
be the problem
Luc
-Original Message-
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: vrijdag 20 november 2009
On Friday 20 November 2009 6:43:53 am Pavel Stehule wrote:
2009/11/20 Tom Lane t...@sss.pgh.pa.us:
Marvelde, Luc te l.temarve...@nioo.knaw.nl writes:
If I run this SQL query:
sqldf(SELECT
+ dbo_tbl_Terrein.RingCentraleNaam,
+ dbo_tbl_Broedsels.BroedselID
+ FROM
Luc,
You need to contact Gabor Grothendieck (cc'd) about this issue. He is
the package author. I'm sure he will be happy to help.
-Whit
On Fri, Nov 20, 2009 at 11:23 AM, Adrian Klaver akla...@comcast.net wrote:
On Friday 20 November 2009 6:43:53 am Pavel Stehule wrote:
2009/11/20 Tom Lane