SQL select if row into joined table is empty

16 views
Skip to first unread message

Initmax Initmax

unread,
Aug 29, 2015, 3:50:56 AM8/29/15
to Slick / ScalaQuery

Have 2 tables T1 and T2 Does slick 3.0 has any variants select all rows from T1 if into T2 related row does not exists ? 



for example

table user
id---name
1     A
2     B

task
id----idUser
1       1

result == 2,B 



Tried with joinLeft 


myQ.joinLeft(my2Q).filter(el => el._2.isEmpty).groupBy(p => p._1).map(_._1)


but without success 




BR!




Reply all
Reply to author
Forward
0 new messages