**问题:**数据库2张表做关联,A表字段a,B表字段b,如果a列包含b列的内容,就关联,这个应该怎么写?mysql数据库
数据表示例如下:
一、
with Cte1 as (
select 1 as FA, 'a' as FB, 'c' as FC
union all
select 2 as FA, 'b' as FB, 'd' as FC
union all
select 3 as FA, 'c' as FB, 'x' as FC
), Cte2 as (
select 1 as FA, 'c' as FB
union all
select 2 as FA, 'no' as FB
union all
select 3 as FA, 'x' as FB
), Cte21 as (
/*添加存在标准*/
select a.*,