多表联合查询SQL语句
来源:互联网 发布:php后端工程师 编辑:程序博客网 时间:2024/06/02 07:45
$tempSQL = "SELECT portfolio.bmi_no as bmi_no,portfolio.title1 as title1,portfolio.lname1 as lname1,portfolio.fname1 as fname1,member.login_name as login_id, portfolio.lname2 as lname2,portfolio.fname2 as fname2,portfolio.principle as principle,portfolio.email as email,portfolio.policy_no as policy_no,portfolio_file.en_file as en_file,portfolio_file.en_enable as en_enable,policy_status.problem_type as problem_type
FROM `portfolio` LEFT JOIN `member` ON portfolio.full_name=member.full_name and portfolio.dob=member.dob
LEFT JOIN `policy_status` ON portfolio.policy_no = policy_status.policy_no AND policy_status.is_live =1
LEFT JOIN `policy_fund` ON portfolio.principle=policy_fund.principle AND portfolio.policy_no=policy_fund.policy_no AND policy_fund.is_live=1
LEFT JOIN `portfolio_file` on portfolio.bmi_no = portfolio_file.bmi_no AND ".$report_criteria;
解释之后的SQL语句:
FROM `portfolio`
LEFT JOIN `member` ON portfolio.full_name= member.full_name
AND portfolio.dob= member.dob
LEFT JOIN `policy_status`ON portfolio.policy_no= policy_status.policy_no
AND policy_status.is_live=1
LEFT JOIN `policy_fund`ON portfolio.principle= policy_fund.principle
AND portfolio.policy_no= policy_fund.policy_no
AND policy_fund.is_live=1
LEFT JOIN `portfolio_file`ON portfolio.bmi_no= portfolio_file.bmi_no
AND portfolio_file.year= '2011'
AND portfolio_file.month= '12'
LIMIT 0 , 30
- 多表联合查询SQL语句
- SQL语句多表联合查询
- 多表联合查询的sql语句
- sql语句一例:多表联合查询
- 三表联合查询的sql语句
- sql语句联合查询详解
- SQL 多表联合查询
- SQL 多表联合查询
- sql 多表联合查询
- SQL 多表联合查询
- sql-多表联合查询
- SQL多表联合查询
- SQL多表联合查询
- 联合查询SQL语句和翻页语句
- 对多表联合查询的SQl语句的改进,大幅提高查询性能
- 又一个通用分页存储过程,支持表别名,多表联合查询SQL语句
- 又一个通用分页存储过程,支持表别名,多表联合查询SQL语句--转载
- SQL语句对于多表联合查询重复字段的特殊语法处理
- SQL Server 索引结构及其使用(一)[转]
- Shell是什么?
- C拾遗(四)指指针阵
- 使用rmp实现yum工具的安装
- error C2146: 语法错误 : 缺少“;”(在标识符“PVOID64”的前面)[转]
- 多表联合查询SQL语句
- java和c/c++ 数据类型长度对比
- 目标13——在Yii中使用ajax
- 关于字符的编码和转码URLEncode URLDecode
- 为什么要学JavaScript?
- MPEG4 笔记2(FTYP,MOOV,MVHD)
- Visual Basic 实现计算器
- IE兼容性的问题
- linux下的安排任务