Jack- and everyone else- Can we say ' stupid idiot ' ?

Cause that's how I am feeling right now

Here is the query from the source table

This is funny in a sad way!!!

I did a single query and noticed that my source table had
5 unique records- this table has no constraints,

I then did a select po_num and po_line on the po
and look what I found- I am thinking that when the data was converted
from
another table(production) somehow the field length became len=1 or all
double digit numbers got cropped, those extra (1) ones are really
10,11,12 etc...

I will need to rework my data- then I will cry wolf if necessary.
SQL> select po_number,po_line_number
2 from temp_pop_lines
3 where po_number='0100196'
4 ;
0100196 1
0100196 2
0100196 3
0100196 4
0100196 5
0100196 6
0100196 7
0100196 8
0100196 9
0100196 1
0100196 1
0100196 1
0100196 1

My bad- I just could not believe I had any bad data- Quelle drolle
Thanks to everyone who has given there time - I will return the favor
when I can.
regards
Jim T

Oracle LazyDBA home page