現有表
t_student:
id, name, class_id
t_class:
id, name
問題:
如何使用Specification 實作如下查詢:
SELECT a.id, a.name, a.class_id FROM t_student a JOIN t_class b ON a.class_id = b.id ORDER BY b.name;
SELECT a.id, a.name, a.class_id FROM t_student a JOIN t_class b ON a.class_id = b.id ORDER BY b.name;
SELECT a.id, a.name, a.class_id FROM t_student a JOIN t_class b ON a.class_id = b.id ORDER BY b.name;
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/60457.html
標籤:應用實例
上一篇:奈何沒帶電腦無法完成,老煩大神了
