[SQL] Sqldf - error message

2009-11-20 Thread Marvelde, Luc te
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:

Re: [SQL] Sqldf - error message

2009-11-20 Thread Tom Lane
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)

Re: [SQL] Sqldf - error message

2009-11-20 Thread Pavel Stehule
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

Re: [SQL] Sqldf - error message

2009-11-20 Thread Pavel Stehule
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

Re: [SQL] Sqldf - error message

2009-11-20 Thread Marvelde, Luc te
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

Re: [SQL] Sqldf - error message

2009-11-20 Thread Adrian Klaver
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

Re: [SQL] Sqldf - error message

2009-11-20 Thread Whit Armstrong
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