Context Navigation

bgtool_chipinputs.sql

Timestamp:

Mar 5, 2013, 2:24:05 PM (13 years ago)

Author:

eugene

Message:

merge changes from trunk

Location:

branches/eam_branches/ipp-20130207

Files:

Property svn:mergeinfo set to

/branches/czw_branch/20101203/ippTools/share	merged	eligible
/branches/czw_branch/20120906/ippTools/share	merged	eligible
/branches/czw_branch/20130211/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20101103/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20101205/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20110213/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20110404/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20110505/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20110710/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20110906/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20111110/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20120405/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20120601/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20120627/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20120805/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20120905/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20121130/ippTools/share	merged	eligible
/branches/eam_branches/ipp-20121219/ippTools/share	merged	eligible
/branches/haf_add201112/ippTools/share	merged	eligible
/trunk/ippTools/share	merged	eligible

-              r28486
+              r35236
 SELECT
+    chipProcessedImfile.*
+    chipProcessedImfile.*,
+    camProcessedExp.path_base AS cam_path_base
 FROM chipBackgroundRun
 JOIN chipRun USING(chip_id)
 JOIN chipProcessedImfile USING(chip_id)
+LEFT JOIN camProcessedExp ON chipBackgroundRun.cam_id = camProcessedExp.cam_id
 WHERE chipRun.state = 'full'
     AND chipProcessedImfile.fault = 0

Note: See TracChangeset for help on using the changeset viewer.