SQL Complex Statement Logging

Check all surgical appointments and the corresponding arrangement, if the scheduled PK is not NULL, then separated by commas (if there are multiple). The SQL statements in MySQL are as follows:

[SQL]View Plaincopyprint?

2. Select distinct a.pk, A.surgeryname, A.clerkname, A.customername, A.ordertime, B.forecasttime, b.pk surgery_pk,
4. Case
6. When c.pk was not null then (select Group_concat (d.pk) from surgery_arrange D where d.su rgery_order_fk=a.pk)
8. else null end SURGERY_ARRANGE_PK
10. From (Surgery_order a left join surgery B on a.surgery_fk=b.pk) left join Surgery_arrange C on A.P K=C.SURGERY_ORDER_FK
12. ORDER by SURGERY_ARRANGE_PK desc, a.ordertime ASC
14. Limit 0,10

SQL Complex Statement Logging