LumiDB/doc/initializeHFtag.sql

0001 insert into tagruns (tagid,runnum) (select distinct 0, runnum from lumidata);
0002 update tagruns set  lumidataid=(select max(data_id) from lumidata where lumidata.runnum=tagruns.runnum);
0003 update tagruns set  trgdataid=(select max(data_id) from trgdata where trgdata.runnum=tagruns.runnum);
0004 update tagruns set  hltdataid=(select max(data_id) from hltdata where hltdata.runnum=tagruns.runnum);