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

Index: src/hg/utils/automation/synBlastp.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/utils/automation/synBlastp.csh,v
retrieving revision 1.3
retrieving revision 1.4
diff -b -B -U 4 -r1.3 -r1.4
--- src/hg/utils/automation/synBlastp.csh	13 Feb 2007 01:37:29 -0000	1.3
+++ src/hg/utils/automation/synBlastp.csh	26 Sep 2009 21:22:51 -0000	1.4
@@ -128,9 +128,10 @@
 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.
-hgsql $db -BN -e "delete ${xxBlastTab} 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 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"
 
 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"