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 vote157 views1 answer
Pl sql search saurce code
SQL
0 vote142 views2 answers
Mysql slave status
SQL
0 vote153 views1 answer
Pl sql disable trigger
SQL
0 vote167 views1 answer
Consecutive numbers sql
SQL
0 vote176 views1 answer
Select top 3 sql
SQL
0 vote147 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote175 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
-1 vote176 views1 answer
Capitole toulouse
SQL
0 vote253 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
3 votes172 views1 answer
Where id is in list sql
SQL