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 vote355 views1 answer
Postgres get month name from date
SQL
0 vote359 views1 answer
Mysql multiple primary keys
SQL
0 vote369 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote350 views1 answer
Python mysql query to dataframe
SQL
2 votes358 views1 answer
Tsql copy table
SQL
22 votes341 views3 answers
Sql cheat sheet
SQL
0 vote365 views1 answer
How to start my sql server on mac
SQL
0 vote343 views1 answer
Mysql select where field is a value
SQL
2 votes373 views1 answer
Q operator in sql
SQL
0 vote382 views1 answer
How to select all fieldsin a soql query
SQL