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 vote393 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote336 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
-3 votes450 views8 answers
Sql to c# linq converter online
SQL
1 vote353 views1 answer
Pagination sql
SQL
3 votes374 views1 answer
Sql add two values together
SQL
0 vote364 views2 answers
How to create a table from another table in sql derby
SQL
0 vote327 views1 answer
Jooq finding lastest value in table
SQL
28 votes356 views4 answers
Show tables mysql
SQL
0 vote392 views1 answer
Sql sum show 0 result
SQL
0 vote373 views1 answer
Get a list of tables and the primary key
SQL