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

10 votes250 views1 answer
Oracle view dependencies
SQL
2 votes308 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
1 vote298 views1 answer
Rename table column name in mysql
SQL
1 vote319 views1 answer
Connect to mysql database ubuntu
SQL
0 vote318 views1 answer
Select place default lat long
SQL
5 votes295 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote274 views1 answer
Update set with join pl sql
SQL
1 vote304 views2 answers
Postgresql remote connect
SQL
6 votes306 views2 answers
Psql load dump
SQL
4 votes281 views1 answer
Mysql set max connections
SQL