要看你的mysql是什么版本了。。5.7以下的版本是不支持with用法的，如果你的mysql支持的话。。就参考类似如下写

1. WITH

2. T3 AS

3. (

4. SELECT T1.ID, T1.CODE1, T2.DESCRIPTION

5. FROM TB_DATA T1, TB_CODE T2

6. WHERE T1.CODE1 = T2.CODE

7. ),

8. T4 AS

9. (

10. SELECT T1.ID, T1.CODE2, T2.DESCRIPTION

11. FROM TB_DATA T1, TB_CODE T2

12. WHERE T1.CODE2 = T2.CODE

13. )

14. SELECT T3.ID, T3.DESCRIPTION, T4.DESCRIPTION

15. FROM T3, T4

16. WHERE T3.ID = T4.ID

17. ORDER BY ID;

https://zhuanlan.zhihu.com/p/397195826

参考

with  data1 as (select * from a), data2 as (select * from b), data3 as (select * fromc)  select * from data1  left join data2 on data1.id = data2.id left join data3  on data1.id = data3.id 

语法基本上就是上面这样，具体的你没给出来，也写不了，with as 就是临时表，然后开始第一个是with as  后面跟着的临时表就加上逗号 加上临时表的表名加上 as 就行了， 然后最后一个不需要逗号结尾，直接写一个总的