How to join another table when using DELETE

20 views
Skip to first unread message

Leon Zhou

unread,
Nov 4, 2015, 2:12:17 AM11/4/15
to Korma

It seems JOIN only working with SELECT,any solution for DELETE with JOIN?
I want execute sql like below:

delete t 
from task  t  
join user u 
on (t.user_id and u.id
where t.id = 100 
and u.id=1

I do not know how to figure it out.

Thanks.

Immo Heikkinen

unread,
Nov 10, 2015, 2:08:28 PM11/10/15
to sqlk...@googlegroups.com
Looks like delete in Korma doesn't support join at the moment. Pull request welcome. 

--
You received this message because you are subscribed to the Google Groups "Korma" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlkorma+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages