SQL statement records, SQL statements

SQL statement records, SQL statements

Query all surgical appointments and the corresponding schedule. If the pk is not null, separate them with commas ). The SQL statement in mysql is as follows:

Select distinct. pk,. surgeryName,. clerkName,. customerName,. orderTime, B. forecastTime, B. pk surgery_pk, case when c. pk is not null then (select group_concat (d. pk) from surgery_arrange d where d. surgery_order_fk =. pk) else null end surgery_arrange_pk from (surgery_order a left join surgery B on. surgery_fk = B. pk) left join surgery_arrange c on. pk = c. surgery_order_fk order by surgery_arrange_pk desc,. orderTime asc limit 0, 10

The result is shown in: