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 vote302 views1 answer
Stop mysql server mac
SQL
2 votes298 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
2 votes318 views1 answer
Add new column not null sql server
SQL
1 vote342 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote305 views2 answers
Create new table plsql
SQL
0 vote346 views1 answer
Create table split string function in sql server
SQL
0 vote315 views1 answer
Start and stop mysql
SQL
0 vote339 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote325 views2 answers
Soql last year
SQL
1 vote322 views1 answer
Get table column names sql ssms
SQL