Re: [R] question on sqldf syntax

2010-01-26 Thread Christian Schulz
Maybe that's a "problem" with the RSQLite package , probably detaching the package help. detach("package:RSQLite") HTH, Christian trying to structure sql to merge two datasets. structure follows: dbs.possible.combos (all possible combinations of dates and places) Date Place 1/1/10 N-01 1/1/

Re: [R] question on sqldf syntax

2010-01-25 Thread Gabor Grothendieck
On Mon, Jan 25, 2010 at 2:17 PM, GL wrote: > > trying to structure sql to merge two datasets. structure follows: > > dbs.possible.combos (all possible combinations of dates and places) > Date Place > 1/1/10 N-01 > 1/1/10 S-02 > 1/2/10 N-01 > 1/2/10 S-02 > etc... > > dbs.aggregate (the raw data agg

Re: [R] question on sqldf syntax

2010-01-25 Thread lith
On 25 Jan., 20:26, GL wrote: > Actually, better sql would likely be: > > dbs.final <- sqldf("select * from dbs.possible.combos left join > dbs.aggregate using (Date,Place)") > > but this still doesn't work I'd suspect name mangling to cause the problem: http://code.google.com/p/sqldf/#2._Why_does

Re: [R] question on sqldf syntax

2010-01-25 Thread GL
Actually, better sql would likely be: dbs.final <- sqldf("select * from dbs.possible.combos left join dbs.aggregate using (Date,Place)") but this still doesn't work -- View this message in context: http://n4.nabble.com/question-on-sqldf-syntax-tp1289707p1289718.html Sent from the R help maili

[R] question on sqldf syntax

2010-01-25 Thread GL
trying to structure sql to merge two datasets. structure follows: dbs.possible.combos (all possible combinations of dates and places) Date Place 1/1/10 N-01 1/1/10 S-02 1/2/10 N-01 1/2/10 S-02 etc... dbs.aggregate (the raw data aggregated by date and location) Date Place Days 1/1/10 N-01 6 1/1/1