select
--
AM_SynthesisRPTData.Code,AM_SynthesisRPTData.RPTTemplateID as DataTemplateID
--
AM_SynthesisRPTData.*,BB.*,CC.RPTItemName,CC.DispNo
*
from
AM_SynthesisRPTData
join
AM_SynthesisRPTTemplate BB
on
BB.RPTTemplateID
=
AM_SynthesisRPTData.RPTTemplateID
join
AM_SynthesisRPTItem CC
on
CC.RPTItemID
=
BB.RPTItemID
where
1
=
1
and
exists
(
select
*
from
(
select
AM_SynthesisRPTTemplate.
*
,AM_SynthesisRPTItem.RPTItemName,AM_SynthesisRPTItem.DispNo
from
AM_SynthesisRPTTemplate
join
AM_SynthesisRPTItem
on
AM_SynthesisRPTItem.RPTItemID
=
AM_SynthesisRPTTemplate.RPTItemID
left
join
AM_SynthesisRPTElement
on
AM_SynthesisRPTElement.RPTElementID
=
AM_SynthesisRPTTemplate.RPTElementID
where
CellType
=
1
)
as
B
where
B.RPTTemplateID
=
AM_SynthesisRPTData.RPTTemplateID )
and
BB.RPTID
=
2
and
CC.RPTItemID
<>
14
and
CC.RPTITemID
<>
15
and
code
=
'
DA619C04-1499-4E39-AD16-518835FF775C
'
order
by
GroupID,dispNo
--
desc
本文转自Sam Lin博客园博客，原文链接：http://www.cnblogs.com/samlin/archive/2008/03/05/1092133.html，如需转载请自行联系原作者
