views:

107

answers:

0

I use subsonic 2.2 and C# and can't figure out the correct syntax to accomplish a multi-row delete that I would code in SQL as:

delete Documents
from  Documents d
join  Job_document_ref r
on    r.document_id = d.document_id
where r.job_id = @jobid

Thanks.