select t_info.id,t_info.tel,t_man.name,t_man.add,t_info.long,t_info,xm,t_info.context from t_info,t_man where t_info.id='给定值' and t_info.tel=t_man.tel

解决方案 »

  1.   

    select 
    t_info.id,
    t_info.tel,
    t_man.name,
    t_man.add,
    t_info.long,
    t_info.xm,
    t_info.context
    from t_man,t_info
    where t_man.tel=t_info.tel
    and t_info.id = '给定值'
      

  2.   

    select t_info.id,
    t_info.tel,
    t_man.name,
    t_man.add,
    t_info.long,
    t_info.xm,
    t_info.context from t_info,t_man
    where t_info.tel = t_man.tel and t_info.id = '给定值'
      

  3.   

    select t_info.id,
    t_info.tel,
    t_man.name,
    t_man.add,
    t_info.long,
    t_info.xm,
    t_info.context
    from t_info,t_man
    where t_info.id=给定值
    and t_info.tel = t_man.tel