src/hg/utils/automation/synBlastp.csh 1.5

Index: src/hg/utils/automation/synBlastp.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/utils/automation/synBlastp.csh,v
retrieving revision 1.4
retrieving revision 1.5
diff -b -B -U 4 -r1.4 -r1.5
--- src/hg/utils/automation/synBlastp.csh	26 Sep 2009 21:22:51 -0000	1.4
+++ src/hg/utils/automation/synBlastp.csh	27 Sep 2009 03:32:29 -0000	1.5
@@ -128,10 +128,9 @@
 set sql = "select count(distinct query) from ${xxBlastTab}"; echo "old number of unique query values:"; hgsql $db -BN -e "$sql"
 set sql = "select count(distinct target) from ${xxBlastTab}"; echo "old number of unique target values"; hgsql $db -BN -e "$sql"
 
 # drop rows that do not have a match in the psl-mapped otherDb table.
-set yyBlastTab = ${otherDb}.temp${otherDb}kgTo${db}kg
-hgsql $db -BN -e "delete ${xxBlastTab} from ${xxBlastTab} left join ${yyBlastTab} on (${xxBlastTab}.query = ${yyBlastTab}.value and ${xxBlastTab}.target = ${yyBlastTab}.name) where ${yyBlastTab}.value is NULL"
+hgsql $db -BN -e "delete a from ${xxBlastTab} a left join ${otherDb}.temp${otherDb}kgTo${db}kg b on (a.query = b.value and a.target = b.name) where b.value is NULL"
 
 set sql = "select count(distinct query) from ${xxBlastTab}"; echo "new number of unique query values:"; hgsql $db -BN -e "$sql"
 set sql = "select count(distinct target) from ${xxBlastTab}"; echo "new number of unique target values"; hgsql $db -BN -e "$sql"