一条语句的有关问题 散分了

一条语句的问题 散分了~strsqldeletea,bfromcs_infoarightjoincs_dingbona.ctelb.ctelwherea.cname&T

一条语句的问题 散分了~
strsql   =   "delete   a,   b   from   cs_info   a   right   join   cs_ding   b   on   a.ctel=b.ctel   where   a.cname= ' "   &   Trim(Text1.Text)   &   " '   and   b.cdtime= ' "   &   DTPicker1.Value   &   " '


DELETE语句不能删除两个表的数据
那分开怎么写???????????????/

[解决办法]
一次只能删除一个表

要不这样:
select a.主键 as a, b.主键 as b into # from cs_info a right join cs_ding b on a.ctel=b.ctel where a.cname= ' " & Trim(Text1.Text) & " ' and b.cdtime= ' " & DTPicker1.Value & " '


delete cs_info
from # a
where a.a=cs_info.主键

delete cs_ding
from # a
where a.b=cs_ding.主键