Sql join on comma separated field

SELECT * FROM `TABLE1`
JOIN `TABLE2` ON `TABLE1`.`id` = `TABLE2`.`COMMA_SEPERATED_COLUMN` 
AND `TABLE2`.`COMMA_SEPERATED_COLUMN` REGEXP "(^|,)SPECIFIC_ID(,|$)"

############## OR #######################

SELECT * FROM table1 
LEFT JOIN table2 ast ON ast.nodeid = c_NodeId 
AND ',' + ast.GroupNames + ',' LIKE '%,' + table1.GroupAlphabet + ',%';

Comma seperated join mssql

select SM.ROLLNO,
       SM.NAME, 
       SM.ADDRESS,
       (
       select ','+CM.CourseName
       from dbo.CourseMaster as CM
       where ','+SM.Course+',' like '%,'+CM.CourseId+',%'
       for xml path(''), type
       ).value('substring(text()[1], 2)', 'varchar(max)') as Course
from dbo.StudentMaster as SM;

Source: dba.stackexchange.com

Similar codes

0 vote297 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote329 views1 answer
Modifier une valeur sql
SQL
1 vote293 views1 answer
Get url of cpanel database hostname
SQL
0 vote294 views1 answer
Sql create table with references not primary key
SQL
0 vote313 views1 answer
Adding primery key constraint to a column
SQL
1 vote290 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote401 views1 answer
Compare strings lexicographically in sql
SQL
0 vote342 views3 answers
Sql parenthetical expression examples
SQL
0 vote296 views3 answers
Drop multiple columns in sql
SQL
0 vote295 views1 answer
H2 auto increment and unique
SQL