SELECT
TAGDCF.*
FROM
pf.[Order] AS O
INNER JOIN pfm.[Order] AS ORD ON ORD.RootId# = O.RootID
INNER JOIN pfm.CDF AS C ON C.RootId# = ORD.RootId# AND C.Id# BETWEEN ORD.Id# AND ORD.LastId#
INNER JOIN pfm.CDFLine AS CL ON CL.RootId# = C.RootId# AND CL.Id# BETWEEN C.Id# AND C.LastId#
INNER JOIN pfm.CDFCharge AS CC ON CC.RootId# = CL.RootId# AND CC.Id# BETWEEN CL.Id# AND CL.LastId#
INNER JOIN pfm.TaxAndGovernmentDetailSection AS TAGDS ON TAGDS.RootId# = CC.RootId# AND TAGDS.Id# BETWEEN CC.Id# AND CC.LastId#
INNER JOIN pfm.TaxAndGovernmentDetailChargeFee AS TAGDCF ON TAGDCF.RootId# = TAGDS.RootId# AND TAGDCF.Id# BETWEEN TAGDS.Id# AND TAGDS.LastId#
SELECT
TAGDCF.*
FROM
pf.[Order] AS O
INNER JOIN pfm.[Order] AS ORD ON ORD.RootId# = O.RootID
INNER JOIN pfm.CDF AS C ON C.RootId# = ORD.RootId# AND C.Id# BETWEEN ORD.Id# AND ORD.LastId#
INNER JOIN pfm.CDFLine AS CL ON CL.RootId# = C.RootId# AND CL.Id# BETWEEN C.Id# AND C.LastId#
INNER JOIN pfm.CDFCharge AS CC ON CC.RootId# = CL.RootId# AND CC.Id# BETWEEN CL.Id# AND CL.LastId#
INNER JOIN pfm.TaxAndGovernmentDetailChargeFee AS TAGDCF ON TAGDCF.RootId# = CC.RootId# AND TAGDCF.Id# BETWEEN CC.Id# AND CC.LastId#