多表联合查询SQL语句

最新推荐文章于 2024-08-20 04:56:33 发布

azzfanke

最新推荐文章于 2024-08-20 04:56:33 发布

阅读量829

点赞数

分类专栏： PHP 文章标签： sql join file login email report

本文链接：https://blog.csdn.net/azzfanke/article/details/7092072

版权

PHP 专栏收录该内容

31 篇文章 0 订阅

订阅专栏

$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语句：

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 portfolio_file.year = '2011'
AND portfolio_file.month = '12'
LIMIT 0 , 30