Displaying 2 results from an estimated 2 matches for "formulation_cod".
Did you mean:
formulation_code
2010 Mar 15
1
inner join sqldf
...onth" "item_code"
[5] "res_seqno" "quantity" "directions" "no_of_packs"
[9] "datasource" "scan_ref_no" "name"
"approved_name"
[13] "formulation_code" "strength" "measure_code" "bnf_code"
[17] "bnf_description"
colnames(test_sql_tsf)
[1] "prochi" "prescribed_date" "dataMonth" "item_code"
[5] "res_seqno"...
2010 Mar 12
7
sqldf not joining all the fields
...1/D
CAO0000713 17/09/1993 NULL 39620 NULL 5ML NIL
CAO0000713 01/05/2001 NULL 842752 NULL 60 1/D
CAO0000713 05/03/2001 NULL 842752 NULL 60 1/D
y_data
item_code name formulation_code strength
bnf_code
100 NEONACLEX K TABS NULL 2.2.8
110 NEONACLEX TABS 5MG 2.2.1
50 MESORB DRESS 10CMX10CM 20.3.1
160 ABSORBENT CELLULOSE MESO DRESS 10CMX10CM...