scala - 如何加入 slick？

Question

我有 2 个查询，想像 sql 一样进行连接

例如我有这些表..

object Family extends Table[Long]("Family") {
  def id = column[Long]("id")
  def * = id
}

object Person extends Table[(Long, Long)]("Person") {
  def id = column[Long]("id")
  def FamilyId = column[Long]("FamilyId")
  def * = id ~ FamilyId ~ size
}

Answer 1

val implicitInnerJoin = for {
  c <- Family
  s <- Person if c.id === s.FamilyId
} yield (c.id, s.id)