27,579
社区成员
发帖
与我相关
我的任务
分享
select *
from A left join B on A.字段=B.字段 left join E ON E.字段=B.字段
select A.*
,b.字段
,c.字段
,d.字段
,e.字段
from A left join B on A.字段=B.字段
left join C on A.字段=C.字段
left join D on A.字段=D.字段
left join E ON E.字段=B.字段 or E.字段=C.字段 or E.字段=D.字段
;WITH C1 AS(
SELECT 1 AS ID
UNION ALL SELECT 2 AS ID
UNION ALL SELECT 3 AS ID
UNION ALL SELECT 4 AS ID
),C2 AS (
SELECT 2 AS BID, 3 AS EID
),C3 AS (
SELECT 3 AS CID, 2 AS EID
),C4 AS (
SELECT 4 AS DID, 1 AS EID
),C5 AS (
SELECT 1 AS ID,'V' AS Value
UNION ALL SELECT 2 AS ID,'B'
UNION ALL SELECT 3 AS ID,'M'
UNION ALL SELECT 4 AS ID,'I'
)
SELECT c1.ID,C5.Value
FROM C1
LEFT JOIN C2 ON C1.ID = C2.BID
LEFT JOIN C3 ON C1.ID = C3.CID
LEFT JOIN C4 ON C1.ID = C4.DID
LEFT JOIN C5 ON C5.ID IN (C2.EID,C3.EID,C4.EID)
WHERE C5.Value > ''
ID Value
----------- -----
2 M
3 B
4 V;WITH tempa AS (
SELECT * FROM a inner join b inner join e
),tempb AS (
SELECT ...
),tempd AS (
SELECT ...
)
SELECT * FROM tempa UNION SELECT * FROM tempb...
就这么个语句,你能写select,就行
[/quote]
调一个分页方法,列就是select后面写select 的列,from就写后面就写连接表
比如select b.id form A b
就写成
mod.columns:b.id;
mod.tableName:A b;
固定死的格式,UNION all这个放到tableName里面去根本不认识,直接报错[/quote]
那你这个问题就不是sql的事了,因为sql实现这个非常简单。
应该是你的这个固定格式的问题,应该去问问规定这种固定格式的人怎么解决这类问题。
;WITH tempa AS (
SELECT * FROM a inner join b inner join e
),tempb AS (
SELECT ...
),tempd AS (
SELECT ...
)
SELECT * FROM tempa UNION SELECT * FROM tempb...
就这么个语句,你能写select,就行
[/quote]
调一个分页方法,列就是select后面写select 的列,from就写后面就写连接表
比如select b.id form A b
就写成
mod.columns:b.id;
mod.tableName:A b;
固定死的格式,UNION all这个放到tableName里面去根本不认识,直接报错;WITH tempa AS (
SELECT * FROM a inner join b inner join e
),tempb AS (
SELECT ...
),tempd AS (
SELECT ...
)
SELECT * FROM tempa UNION SELECT * FROM tempb...
就这么个语句,你能写select,就行
SELECT DISTINCT * FROM
(
select E.*
from A left join B on A.字段=B.字段 left join E ON E.字段=B.字段
UNION ALL
select E.*
from A left join C on A.字段=C.字段 left join E ON E.字段=C.字段
UNION ALL
select E.*
from A left join D on A.字段=D.字段 left join E ON E.字段=D.字段
)t