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.