My when uploading I get two sets of data one with 0's and one without.
How can I join the the two toghter using a plsql script.
The id no for the users are the same but the emp no has 0's and the other emp no has no 0's

eg,
PERID | MINID|MINEMP | MAXID|MAXEMP
---------------|----------|----------|----------|---------
8105105584089 | 585|8970006 | 6825|08970006
8709270203084 | 594|8960063 | 6834|08960063
8704150399086 | 599|8947065 | 6839|08947065

"plsql" is oracle

this forum is for microsoft sql server

which are you using?

My apologies, I am using Oracle.
Still a newbee.