Re: Joining to tables problem

ian wrote:
> 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
>

Sometimes, it's the things you cannot see that cause these sorts of issues. In those times, I often turn to the DUMP function to figure out exactly what is stored in the column:

SELECT DUMP(col_whatever) FROM table1 WHERE col_whatever=217725191;

SELECT DUMP(col_whatever) FROM table2 WHERE col_whatever=217725191;

Compare the two results to see if there are differences.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown