[Solved] Ineer Join query with where in scala slick


For inner join you could use slick applicative-join with filter clause.
For example:

val query = for {
  (address, userAddressMapping) <- Address join UserAddressMapping on (_.id === _.addressId)
  if userAddressMapping.userId === 1
} yield (address.id, address.name)

dbConfig.run(query.result)

12

solved Ineer Join query with where in scala slick