重新开贴！关于多表查询。小F姐姐和的各位大侠！！

[空白画映]

刚才开的帖子没有说清楚误导大家了。特开此贴。

红色字体的代码是两个表连查后在插入 SQL sever wkf_crm_dianhua表的代码
insert into wkf_crm_dianhua(f_num,t_num,addtime,losttime,username)
select a.Caller as 分机号码,a.Recver as 拨打的电话号码,a.Starttime as 拨打时时间,a.TimeLength as 通话时长,b.username as 用户名
FROM wkf_crm_jiaohuanji b left join
OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:\Uso\Data\Bill.mdb";User ID=Admin;Password=' )...bill a
on a.Caller=b.fenji where a.Caller=b.fenji

下面想实现4表连查后在插入 SQL sever wkf_crm_dianhua表的代码
把bill数据库的bill表的Caller,Recver,Starttime，TimeLength字段和
wkf_crm_news表的 newsid字段,cataid字段，lianxi字段,k_type字段 还有
wkf_crm_comname表的 comname字段同时插入wkf_crm_dianhua这个表里面,另外[color=#008080]wkf_crm_comname表也有cataid字段并且和 wkf_crm_news表的cataid字段值一样[/color]。

[--小F--]

晕 就差几个连接和字段在上面了吧

[feixianxxx]

[Quote=引用 1 楼 fredrickhu 的回复:]
晕 就差几个连接和字段在上面了吧
[/Quote]
学习FJJ

[SQL77]

[Quote=引用 2 楼 feixianxxx 的回复:]
引用 1 楼 fredrickhu 的回复:
晕 就差几个连接和字段在上面了吧

学习FJJ
[/Quote]
..

[--小F--]

insert into wkf_crm_dianhua(f_num,t_num,addtime,losttime,username,newsid,cataid,lianxi,k_type,comname)
select a.Caller as 分机号码,a.Recver as 拨打的电话号码,a.Starttime as 拨打时时间,a.TimeLength as 通话时长,b.username as 用户名,c.newsid,c.cataid,c.lianxi,c.k_type,d.comname

FROM wkf_crm_jiaohuanji b 
    left join (
        select *
        from OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:\Uso\Data\Bill.mdb";User ID=Admin;Password=' )...bill
        ) as a 
        on a.[Caller]=b.fenji 
where
 a.[Caller]=b.fenji
left join
 wkf_crm_news c
on
 关联字段
left join
  wkf_crm_comname d
on
  c.cataid=d.cataid
 

[guguda2008]

你是想INNER JOIN 还是UNION ALL

[空白画映]

刚才没有回复上。。 嗯要的 就是多表练的时候 lift join on 的用法！！

[空白画映]

[Quote=引用 4 楼 fredrickhu 的回复:]
SQL code
insert into wkf_crm_dianhua(f_num,t_num,addtime,losttime,username,newsid,cataid,lianxi,k_type,comname)
select a.Caller as 分机号码,a.Recver as 拨打的电话号码,a.Starttime as 拨打时时间,a.TimeLength as 通话时长,……
[/Quote]

我执行这段代码 说lift join 附近语法错误 13行！

[htl258_Tony]

[Quote=引用 7 楼 junjie94bei 的回复:]
引用 4 楼 fredrickhu 的回复:
SQL code
insert into wkf_crm_dianhua(f_num,t_num,addtime,losttime,username,newsid,cataid,lianxi,k_type,comname)
select a.Caller as 分机号码,a.Recver as 拨打的电话号码,a.Starttime as 拨打时……
[/Quote]

insert into wkf_crm_dianhua(f_num,t_num,addtime,losttime,username,newsid,cataid,lianxi,k_type,comname)
select a.Caller as 分机号码,a.Recver as 拨打的电话号码,a.Starttime as 拨打时时间,a.TimeLength as 通话时长,b.username as 用户名,c.newsid,c.cataid,c.lianxi,c.k_type,d.comname

FROM wkf_crm_jiaohuanji b 
    left join (
        select *
        from OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:\Uso\Data\Bill.mdb";User ID=Admin;Password=' )...bill
        ) as a 
        on a.[Caller]=b.fenji 
    left join wkf_crm_news c
        on 条件
    left join wkf_crm_comname d
        on c.cataid=d.cataid

只改语法部份

[ACMAIN_CHM]

小F姐姐 - 即不是JJ，也不是GG。
小F的性别是随机的。

[空白画映]

小F 不是姐姐？