Re: Help with a query using nested queries
Quote
I have a table(A) that has a string (123:456:789) which are IDs of work sectors(in table B).
Read up on Data Normalisation.
select *
from TableA ;
+----+-
| Id | ...
+----+-
| 1 | ...
+----+-
select *
from TableB ;
+----+--------------+-
| Id | Section_Name | ...
+----+--------------+-
| 22 | 123 | ...
| 33 | 456 | ...
| 44 | 789 | ...
+----+--------------+-
select * from TableA_WorkSections ;
+------+------+
| A_ID | B_Id |
+------+------+
| 1 | 22 |
| 1 | 33 |
| 1 | 44 |
+------+------+
Regards, Phill W.
Subject
Written By
Posted
September 10, 2014 03:06PM
Re: Help with a query using nested queries
September 11, 2014 08:19AM
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.