较复杂的SQL左链接查询
来源:互联网 发布:linux rm -f 编辑:程序博客网 时间:2024/06/06 08:53
SELECT
c.*,
t.contract_product_id,t.factory_name,t.product_no,t.product_desc,t.cnumber,t.packing_unit,t.price,t.amount,
t.ext_cproduct_id,t.ext_factory_name,t.ext_product_no,t.ext_product_desc,t.ext_cnumber,t.ext_packing_unit,t.ext_price,t.ext_amount
FROM
(SELECT * FROM contract_c) c
LEFT JOIN
(
SELECT
cp.contract_id,
cp.contract_product_id,cp.factory_name,cp.product_no,cp.product_desc,cp.cnumber,cp.packing_unit,cp.price,cp.amount,
ep.ext_cproduct_id,ep.factory_name AS ext_factory_name,ep.product_no
AS ext_product_no,ep.product_desc as ext_product_desc,ep.cnumber as
ext_cnumber,ep.packing_unit as ext_packing_unit,ep.price as
ext_price,ep.amount as ext_amount
FROM
(
SELECT
cp.contract_product_id,cp.contract_id,f.factory_name,cp.product_no,
cp.product_desc,cp.cnumber,cp.packing_unit,cp.price,cp.amount
FROM
(SELECT contract_product_id,contract_id,factory_id,product_no,
product_desc,cnumber,packing_unit, price,amount FROM
contract_product_c) cp
LEFT JOIN
(SELECT factory_id,factory_name FROM factory_c) f
ON cp.factory_id =
f.factory_id
) cp
LEFT JOIN
(
SELECT
ep.ext_cproduct_id,ep.contract_product_id,f.factory_name,ep.product_no,
ep.product_desc,ep.cnumber,ep.packing_unit,ep.price,ep.amount
FROM
(SELECT ext_cproduct_id,contract_product_id,factory_id,product_no,
product_desc,cnumber,packing_unit, price,amount FROM ext_cproduct_c)
ep
LEFT JOIN
(SELECT factory_id,factory_name FROM factory_c) f
ON
ep.factory_id=f.factory_id
) ep
ON cp.contract_product_id=ep.contract_product_id
) t
ON c.contract_id=t.contract_id
c.*,
t.contract_product_id,t.factory_name,t.product_no,t.product_desc,t.cnumber,t.packing_unit,t.price,t.amount,
t.ext_cproduct_id,t.ext_factory_name,t.ext_product_no,t.ext_product_desc,t.ext_cnumber,t.ext_packing_unit,t.ext_price,t.ext_amount
FROM
(SELECT * FROM contract_c) c
LEFT JOIN
(
SELECT
cp.contract_id,
cp.contract_product_id,cp.factory_name,cp.product_no,cp.product_desc,cp.cnumber,cp.packing_unit,cp.price,cp.amount,
ep.ext_cproduct_id,ep.factory_name AS ext_factory_name,ep.product_no
AS ext_product_no,ep.product_desc as ext_product_desc,ep.cnumber as
ext_cnumber,ep.packing_unit as ext_packing_unit,ep.price as
ext_price,ep.amount as ext_amount
FROM
(
SELECT
cp.contract_product_id,cp.contract_id,f.factory_name,cp.product_no,
cp.product_desc,cp.cnumber,cp.packing_unit,cp.price,cp.amount
FROM
(SELECT contract_product_id,contract_id,factory_id,product_no,
product_desc,cnumber,packing_unit, price,amount FROM
contract_product_c) cp
LEFT JOIN
(SELECT factory_id,factory_name FROM factory_c) f
ON cp.factory_id =
f.factory_id
) cp
LEFT JOIN
(
SELECT
ep.ext_cproduct_id,ep.contract_product_id,f.factory_name,ep.product_no,
ep.product_desc,ep.cnumber,ep.packing_unit,ep.price,ep.amount
FROM
(SELECT ext_cproduct_id,contract_product_id,factory_id,product_no,
product_desc,cnumber,packing_unit, price,amount FROM ext_cproduct_c)
ep
LEFT JOIN
(SELECT factory_id,factory_name FROM factory_c) f
ON
ep.factory_id=f.factory_id
) ep
ON cp.contract_product_id=ep.contract_product_id
) t
ON c.contract_id=t.contract_id
阅读全文
0 0
- 较复杂的SQL左链接查询
- 较复杂的sql语句
- sql子查询左链接
- SQL复杂的查询
- 利用游标实现较复杂的多表查询
- 复杂的sql数据库查询
- sql的复杂查询步骤
- sql 数据库,左外链接和查询结果某一项添加自定义字符串的情况
- SQL的 内链接 左链接 右链接
- 制作较复杂的电路板
- maven - 较复杂的实例
- 一分钟内掌握较复杂sql
- 第一次写成功的复杂sql查询
- ms sql复杂点的查询
- SQL复杂查询语句的使用
- sql语句复杂查询的思路
- mysql 复杂sql子查询的实例
- 条件复杂的sql语句查询
- HDU 2594 两串合为一串,利用nex数组巧解
- Linux下设置Redis开机自启
- linphone3.9windows编译心得
- Maven依赖调解和可选依赖
- 生成对抗网络学习笔记3----论文unsupervised representation learning with deep convolutional generative adversarial
- 较复杂的SQL左链接查询
- yara语法简介
- 形式化
- java 动态代理
- 匿名函数 lambda表达式
- Mac上安装scrapy
- Jquery--表单验证插件FormValidator
- 最强 Android Studio 使用小技巧和快捷键
- 如何在IDE中运行elasticsearch