SQL query 一问# Database - 数据库
a*8
1 楼
I have three tables,
Student(sID, name)
Course(cID, title)
Registration(sID, cID)
I'd like to get result-set with 2 columns.
name | Course title list separated by semicolon(;)
How to implement in SQL or stored procedure?
Student(sID, name)
Course(cID, title)
Registration(sID, cID)
I'd like to get result-set with 2 columns.
name | Course title list separated by semicolon(;)
How to implement in SQL or stored procedure?