Re: Joining tables with RIGHT statement
> Like: A.number: 456, B.number: 23 456
> For aesthetic reason I want to remove the first numbers
> so the numbers left in B is the same in A (A.number:456, B.number:456).
That needs to be done for fundamental database design reasons. Multiple values in single fields turn the tatabase design they occur in into nonsense. You need to read about normalisation, then redesign these tables, and only then write the SQL required to populate the new tables.
Subject
Written By
Posted
Re: Joining tables with RIGHT statement
August 24, 2015 04:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.