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 vote222 views2 answers
Mysql add column tinyint default 0
SQL
1 vote177 views1 answer
Login to database mysql terminal
SQL
0 vote193 views1 answer
H2 auto increment and unique
SQL
5 votes217 views1 answer
Oracle nls instance
SQL
0 vote188 views1 answer
Postgresql stored procedure update table values
SQL
1 vote185 views1 answer
Psql autocomplete for mac brew install
SQL
1 vote203 views2 answers
Mysql insert generate serie
SQL
0 vote186 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
6 votes268 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote199 views1 answer
Mysqldump don't drop table
SQL