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 vote278 views1 answer
Select if then postgresql
SQL
0 vote286 views2 answers
Psql commande \gset
SQL
15 votes289 views4 answers
Mysql export database command line
SQL
0 vote288 views1 answer
Delete first row in sql
SQL
1 vote273 views1 answer
Install postgresql on raspberry pi
SQL
0 vote298 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
1 vote286 views1 answer
Sql server epoch to datetime
SQL
5 votes257 views1 answer
Oracle list packages
SQL
0 vote239 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
3 votes255 views4 answers
Show sql server database
SQL