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()