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