SORM的关联查询

case class Person(name: String)
case class Department(name: String)
case class PersonDepartment(person: Person, department: Department)
case class Order(person: Person, title: String)

import sorm.Dsl._
import sorm._

val orders = db.query[Order]
		.whereIn("person",
				db.query[PersonDepartment]
				.where(
						(("person.name" equal "lucy") or
						("person.name" equal "maven"))
						and ("department.name" equal "Basic Process Unit")
				)
              .fetch().map(_.person)
)
.fetch()