 ;
 commit;
 
--- 4. Add any translations not found in the data, but provided by the input tables
+-- 4. Add any translations not found in the data, but provided by the input tables and have drugs containing them
 insert into x_ing
 select distinct
   qi_code as qi_combo,

;

/*************************************************************************
* 3. Create translation tables between q and r attributes with corridors *
**************************************************************************/

-- Create comparison between q_uds and r_uds for everything in the 90% corridor

commit;

/**************************************************************************
* 7. Create the list of all all existing r products in attribute notation * 
***************************************************************************/
drop table existing_r purge;
create table existing_r nologging as
