[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