What about y_data? On Fri, Mar 12, 2010 at 12:14 PM, Newbie19_02 <nvanzuy...@gmail.com> wrote: > > dput(x_data) > > structure(list(prochi = c("CAO0000713", "CAO0000713", "CAO0000713", > "CAO0000713", "CAO0000713", "CAO0000713", "CAO0000713", "CAO0000713", > "CAO0000713", "CAO0000713"), prescribed_date = c("22/06/2001", > "28/04/2000", "10/04/2000", "03/07/2000", "09/01/2001", "16/10/2001", > "16/08/2001", "17/09/1993", "01/05/2001", "05/03/2001"), dataMonth = > c("NULL", > "NULL", "NULL", "NULL", "NULL", "NULL", "NULL", "NULL", "NULL", > "NULL"), item_code = c("842752", "7800", "842652", "842652", > "842752", "842752", "842752", "39620", "842752", "842752"), res_seqno = > c("NULL", > "NULL", "NULL", "NULL", "NULL", "NULL", "NULL", "NULL", "NULL", > "NULL"), quantity = c("60", "100G", "60", "60", "60", "60", "60", > "5ML", "60", "60"), directions = c("1/D", "A/TD", "1/D", "1/D", > "1/D", "1/D", "1/D", "NIL", "1/D", "1/D"), no_of_packs = c("NULL", > "NULL", "NULL", "NULL", "NULL", "NULL", "NULL", "NULL", "NULL", > "NULL"), datasource = c("TSF", "TSF", "TSF", "TSF", "TSF", "TSF", > "TSF", "TSF", "TSF", "TSF"), scan_ref_no = c("NULL", "NULL", > "NULL", "NULL", "NULL", "NULL", "NULL", "NULL", "NULL", "NULL" > )), .Names = c("prochi", "prescribed_date", "dataMonth", "item_code", > "res_seqno", "quantity", "directions", "no_of_packs", "datasource", > "scan_ref_no"), row.names = c(NA, 10L), class = "data.frame") > > -- > View this message in context: > http://n4.nabble.com/sqldf-not-joining-all-the-fields-tp1590786p1590821.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >
______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.