rare error

From: Zhiliang Hu <zhu_at_genomicfx.com>
Date: Thu, 29 Mar 2001 11:04:22 -0600
Message-ID: <3AC36B16.889B3065@genomicfx.com>

I have a SQL query that works well:

  select a.animalid, b.allele1, b.allele2 from animal_hr a, genotype_hr b
  where a.plate=b.plate AND a.well=b.well AND raw>'900';

However, when I tried portion of the same query:

  select a.animalid, b.allele1, b.allele2 from animal_hr a, genotype_hr b
  where a.plate=b.plate AND a.well=b.well;

Oracle complains:

---

"where a.plate=b.plate AND a.well=b.well

               *
ERROR at line 2:
ORA-01722: invalid number

---

Isn't it strange?

Zhiliang Received on Thu Mar 29 2001 - 11:04:22 CST