แสดงกระทู้
1
ห้อง MS Access / : CrossTab Query Sort
« เมื่อ: 14 ก.ย. 61 , 20:18:30 »
TRANSFORM First(register.grade) AS FIRSTofgrade
SELECT student.id, student.name, student.room, student.num
FROM subject INNER JOIN (student INNER JOIN register ON student.id = register.id) ON subject.code = register.code
GROUP BY student.id, student.name, student.room, student.num
ORDER BY student.room, student.num, [type] & "-" & [register].
SELECT student.id, student.name, student.room, student.num
FROM subject INNER JOIN (student INNER JOIN register ON student.id = register.id) ON subject.code = register.code
GROUP BY student.id, student.name, student.room, student.num
ORDER BY student.room, student.num, [type] & "-" & [register].
โค๊ด: [Select]
[/color]
PIVOT [type] & "-" & [register].[code];
:ouch: :ouch: :ouch:
โพสต์นี้ได้รับคำขอบคุณจาก: mongkong
