Joining to tables problem

From: ian <ipellew_at_yahoo.com>
Date: 4 Oct 2006 08:58:25 -0700
Message-ID: <1159977505.140103.203710@i42g2000cwa.googlegroups.com>

Hi;

What would stop the joining of two tables using a NUMBER(38) on each of the joined columns?

Table 1 has the row with the number 217725191 in col_whatever Table 2 has the row with the number 217725191 in col_whatever when I look at each of the tables.

When I join the tables
WHERE tab1.col_whatever = tab2.col_whatever

No rows returned.

Using SQL*Plus: Release 8.1.7.0.0 - Production on Wed Oct 4 17:56:56 2006

Any ideas?

Regards
Ian Received on Wed Oct 04 2006 - 10:58:25 CDT