Ggtcf

What is better: yes / no radio, or simple checkbox?

Street obstacles in New Zealand

Getting the || sign while using Kurier

Having the player face themselves after the mid-game

Is it safe to abruptly remove Arduino power?

How exactly does an Ethernet collision happen in the cable, since nodes use different circuits for Tx and Rx?

Signed and unsigned numbers

Is it possible that a question has only two answers?

What ability score modifier does a javelin's damage use?

How does Ehrenfest's theorem apply to the quantum harmonic oscillator?

Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?

Why aren't there more Gauls like Obelix?

Is it a Cyclops number? "Nobody" knows!

How do we create new idioms and use them in a novel?

What materials can be used to make a humanoid skin warm?

Would an aboleth's Phantasmal Force lair action be affected by Counterspell, Dispel Magic, and/or Slow?

Is this Paypal Github SDK reference really a dangerous site?

After `ssh` without `-X` to a machine, is it possible to change `$DISPLAY` to make it work like `ssh -X`?

Doesn't allowing a user mode program to access kernel space memory and execute the IN and OUT instructions defeat the purpose of having CPU modes?

Minimizing with differential evolution

Do items de-spawn?

How many characters using PHB rules does it take to be able to have access to any PHB spell at the start of an adventuring day?

Power Strip for Europe

What problems would a superhuman have who's skin is constantly hot?

How Can I match Id from another table

1

I have two Tables First Table is series Table second is a series_type Table and I want to match series_id column in the series_type Table but in a series_type column i have multiple values so how can I match the column id in the series_type Table?

I have two table
1st Table is storage_series

series_id | series_name
 1 | abc
 2 | def
 3 | ghi
 4 | ijk
 |

2nd Table is Storage_Type

storage_type_id| name | series_id
_______________|________|___________________
 1 | JBOD | 1,4,2,3
 2 | RAID5 | 1,2
 3 | RAID6 | 1,3
 4 | DVD | 4

mysql asp.net

share|improve this question

edited Mar 7 at 5:25

fa06

15.9k21018

asked Mar 7 at 5:25

rohit kumar kaserarohit kumar kasera

64

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  expected output, & your so far code, please
  
  – M.Hemant
  Mar 7 at 5:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  list of doom
  
  – danblack
  Mar 7 at 5:40
  

  
  
  
  

add a comment | 

1

I have two Tables First Table is series Table second is a series_type Table and I want to match series_id column in the series_type Table but in a series_type column i have multiple values so how can I match the column id in the series_type Table?

I have two table
1st Table is storage_series

series_id | series_name
 1 | abc
 2 | def
 3 | ghi
 4 | ijk
 |

2nd Table is Storage_Type

storage_type_id| name | series_id
_______________|________|___________________
 1 | JBOD | 1,4,2,3
 2 | RAID5 | 1,2
 3 | RAID6 | 1,3
 4 | DVD | 4

mysql asp.net

share|improve this question

edited Mar 7 at 5:25

fa06

15.9k21018

asked Mar 7 at 5:25

rohit kumar kaserarohit kumar kasera

64

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  expected output, & your so far code, please
  
  – M.Hemant
  Mar 7 at 5:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  list of doom
  
  – danblack
  Mar 7 at 5:40
  

  
  
  
  

add a comment | 

I have two Tables First Table is series Table second is a series_type Table and I want to match series_id column in the series_type Table but in a series_type column i have multiple values so how can I match the column id in the series_type Table?

I have two table
1st Table is storage_series

series_id | series_name
 1 | abc
 2 | def
 3 | ghi
 4 | ijk
 |

2nd Table is Storage_Type

storage_type_id| name | series_id
_______________|________|___________________
 1 | JBOD | 1,4,2,3
 2 | RAID5 | 1,2
 3 | RAID6 | 1,3
 4 | DVD | 4

mysql asp.net

share|improve this question

edited Mar 7 at 5:25

fa06

15.9k21018

asked Mar 7 at 5:25

rohit kumar kaserarohit kumar kasera

64

series_id | series_name
 1 | abc
 2 | def
 3 | ghi
 4 | ijk
 |

storage_type_id| name | series_id
_______________|________|___________________
 1 | JBOD | 1,4,2,3
 2 | RAID5 | 1,2
 3 | RAID6 | 1,3
 4 | DVD | 4

share|improve this question

edited Mar 7 at 5:25

fa06

15.9k21018

asked Mar 7 at 5:25

rohit kumar kaserarohit kumar kasera

64

share|improve this question

edited Mar 7 at 5:25

fa06

15.9k21018

asked Mar 7 at 5:25

rohit kumar kaserarohit kumar kasera

64

edited Mar 7 at 5:25

fa06

15.9k21018

edited Mar 7 at 5:25

fa06

15.9k21018

asked Mar 7 at 5:25

rohit kumar kaserarohit kumar kasera

64

asked Mar 7 at 5:25

rohit kumar kaserarohit kumar kasera

64

1 Answer
1

active

oldest

votes

0

You can try below -

DEMO

SELECT storage_type_id,names,ser_id,group_concat(series_name) value
FROM t1 join t2 
on FIND_IN_SET(
 t1.series_id, t2.ser_id)
 group by storage_type_id,names,ser_id

OUTPUT:

storage_type_id names ser_id value
1 JBOD 1,4,2,3 abc,def,ghi,ijk
2 RAID5 1,2 abc,def
3 RAID6 1,3 abc,ghi
4 DVD 4 ijk

share|improve this answer

answered Mar 7 at 5:41

fa06fa06

15.9k21018

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55036623%2fhow-can-i-match-id-from-another-table%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You can try below -

DEMO

SELECT storage_type_id,names,ser_id,group_concat(series_name) value
FROM t1 join t2 
on FIND_IN_SET(
 t1.series_id, t2.ser_id)
 group by storage_type_id,names,ser_id

OUTPUT:

storage_type_id names ser_id value
1 JBOD 1,4,2,3 abc,def,ghi,ijk
2 RAID5 1,2 abc,def
3 RAID6 1,3 abc,ghi
4 DVD 4 ijk

share|improve this answer

answered Mar 7 at 5:41

fa06fa06

15.9k21018

add a comment | 

0

You can try below -

DEMO

SELECT storage_type_id,names,ser_id,group_concat(series_name) value
FROM t1 join t2 
on FIND_IN_SET(
 t1.series_id, t2.ser_id)
 group by storage_type_id,names,ser_id

OUTPUT:

storage_type_id names ser_id value
1 JBOD 1,4,2,3 abc,def,ghi,ijk
2 RAID5 1,2 abc,def
3 RAID6 1,3 abc,ghi
4 DVD 4 ijk

share|improve this answer

answered Mar 7 at 5:41

fa06fa06

15.9k21018

add a comment | 

You can try below -

DEMO

SELECT storage_type_id,names,ser_id,group_concat(series_name) value
FROM t1 join t2 
on FIND_IN_SET(
 t1.series_id, t2.ser_id)
 group by storage_type_id,names,ser_id

OUTPUT:

storage_type_id names ser_id value
1 JBOD 1,4,2,3 abc,def,ghi,ijk
2 RAID5 1,2 abc,def
3 RAID6 1,3 abc,ghi
4 DVD 4 ijk

share|improve this answer

answered Mar 7 at 5:41

fa06fa06

15.9k21018

SELECT storage_type_id,names,ser_id,group_concat(series_name) value
FROM t1 join t2 
on FIND_IN_SET(
 t1.series_id, t2.ser_id)
 group by storage_type_id,names,ser_id

storage_type_id names ser_id value
1 JBOD 1,4,2,3 abc,def,ghi,ijk
2 RAID5 1,2 abc,def
3 RAID6 1,3 abc,ghi
4 DVD 4 ijk

share|improve this answer

answered Mar 7 at 5:41

fa06fa06

15.9k21018

answered Mar 7 at 5:41

fa06fa06

15.9k21018

answered Mar 7 at 5:41

fa06fa06

15.9k21018