In Boylan,
Code: Select all
FROM dbo.Phrase AS P
INNER JOIN dbo.zrefPhraseGroup AS zPG ON P.PhraseGroupID = zPG.ID
Moderator: Lisa Ennis
Code: Select all
FROM dbo.Phrase AS P
INNER JOIN dbo.zrefPhraseGroup AS zPG ON P.PhraseGroupID = zPG.ID
Code: Select all
SELECT *
FROM pfm.Phrase AS P
INNER JOIN pf.OrderItemType AS OIT ON P.Type#=OIT.ID
WHERE OIT.Name='Instruction'
Code: Select all
ID Code Description
1 NULL
2 BuyerTen Buyer Tentative Statement
3 BuyerFin Buyer Final Statement
4 BorrTen Borrower Tentative Statement
5 BorrFin Borrower Final Statement
6 SellTen Seller Tentative Statement
7 SellFin Seller Final Statement
8 BuySellTen Buyer/Seller Tentative Statement
9 BuySellFin Buyer/Seller Final Statement
10 BuyTenFC Buyer Tentative Statement (fee conversion)
11 BuyFinFC Buyer Final Statement (fee conversion)
12 EstStmt Estimated Statement
13 BuyTen2nd Buyer Tentative 2nd Statement
14 BorrTen2nd Borrower Tentative 2nd Statement
15 BuyFin2nd Buyer Final 2nd Statement
16 BorrFin2nd Borrower Final 2nd Statement
Code: Select all
SELECT
P.Code,
P.[Text],
IG.NameID AS GroupNameID,
zPG.Code AS GroupCode,
zPG.[Description] AS GroupDescription
FROM
pfm.Phrase AS P
LEFT OUTER JOIN pfm.InstructionGroup AS IG ON p.RootId#=IG.RootId# AND P.Id# BETWEEN IG.Id# AND IG.LastId#
LEFT OUTER JOIN zref.PhraseGroup AS zPG ON IG.NameID=zPG.ID
GO