Displaying 1 result from an estimated 1 matches for "test_sql_innerjoin".
2010 Mar 15
1
inner join sqldf
...quot;,
check.names=TRUE, quote= "\"'")
test_sql_tsf <-read.table(file=
http://n4.nabble.com/file/n1593282/test_sql_tsf.txt test_sql_tsf.txt , ,
header=TRUE, sep="\t", dec=".", na.strings="NA", check.names=TRUE, quote=
"\"'")
test_sql_innerjoin <- sqldf("select * test_sql_psd inner join test_sql_tsf
on test_sql_psd.prochi=test_sql_tsf.prochi")
colnames(test_sql_psd)
[1] "prochi" "prescribed_date" "dataMonth" "item_code"
[5] "res_seqno" "...