select a.contactname
from client a,campaign b
where a.companyname=b.clientname and
b.startdate = to_date('02-sep-2002', 'dd-mon-yyyy') and
b.finishdate = to_date('04-apr-2004', 'dd-mon-yyyy'));
from client a,campaign b
where a.companyname=b.clientname and
b.startdate = to_date('02-sep-2002', 'dd-mon-yyyy') and
b.finishdate = to_date('04-apr-2004', 'dd-mon-yyyy'));
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货