MySQL Forums
Forum List  »  Newbie

Re: Help with a query using nested queries
Posted by: Phillip Ward
Date: September 11, 2014 08:19AM

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.

Options: ReplyQuote


Subject
Written By
Posted
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.