小黑小波比.region查询sql语句

1.获取当前用户id,带id在表中查另一个id,然后带着id在表中查region

--查询class表 class_teacher左连接class  ccode关联 并且and 获取当前用户的tucode = ucode(获取当前用户id) 以scode分组 最后查询scode
with cs as (
	select scode from class c join class_teacher t on c.ccode = t.ccode and tucode = '1' group by scode
),
--关联scode,在school表中查询region区域
st as (
	select region from school s join cs on s.scode = cs.scode --530102
),
--最后带着region区域在publisher表中查询,region作为条件查询,取两位数,四位数,六位数,九位数 以及region为空的数据全部查询
pu as(
	select p.* from publisher p join st on p.region = substring(st.region,1,2) or p.region = substring(st.region,1,4) or p.region = substring(st.region,1,6) or p.region = substring(st.region,1,9) or p.region is null or p.region = '' 
)
--然后总查询
select * from pu order by region