网络收藏

select  
        db2admin.t_person_logs.f_logs_id   as   f_logs_id,  
        db2admin.t_person_logs.f_log_id   as   f_log_id,  
        db2admin.t_person_logs.f_start_time   as   f_start_time,  
        db2admin.t_person_logs.f_finish_time   as   f_finish_time,  
        db2admin.t_person_logs.f_kind_id   as   f_kind_id,  
        db2admin.t_person_logs.f_project_id   as   f_project_id,  
        db2admin.t_person_logs.f_content   as   f_content  
  from  
        db2admin.t_project_info   left   outer   join   db2admin.t_person_logs  
              on   (   db2admin.t_project_info.f_project_id     =   db2admin.t_person_logs.f_project_id),  
        db2admin.t_jobkind   left   outer   join   db2admin.t_person_logs  
              on   (   db2admin.t_jobkind.f_kind_id   =   db2admin.t_person_logs.f_kind_id   )  
               
   
  单独与一个表外连接执行都好用。同时使用时提示  
  [ibm][cli   driver][db2/nt]   sql0203n     对列   "db2admin.t_person_logs.f_kind_id"   的引用是有歧义的。     sqlstate=42702  
   
   
  请大家帮帮忙，怎样解决。

推荐阅读

select  
        l1.f_logs_id   as   f_logs_id,  
        l1.f_log_id   as   f_log_id,  
        l1.f_start_time   as   f_start_time,  
        l1.f_finish_time   as   f_finish_time,  
        l1.f_kind_id   as   f_kind_id,  
        l1.f_project_id   as   f_project_id,  
        l1.f_content   as   f_content  
  from  
        t_project_info   left   outer   join   t_person_logs   l1  
              on   (   t_project_info.f_project_id     =   l1.f_project_id),  
        t_jobkind   left   outer   join   t_person_logs   l2  
              on   (   t_jobkind.f_kind_id   =   l2.f_kind_id   )