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

1 vote143 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
1 vote109 views2 answers
Last working day in week date function in sql
SQL
1 vote160 views1 answer
Psql view enum values
SQL
0 vote136 views1 answer
Ms sql database data size
SQL
1 vote195 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
9 votes146 views3 answers
Oracle undo usage by session
SQL
4 votes177 views3 answers
Mysql get column names from table
SQL
-1 vote151 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote148 views1 answer
Alter precision
SQL
0 vote145 views1 answer
Sql change default collation to utf8
SQL