{ for $_x0058_ML_Application in collection("MSRB_Test_be.dbo.XML_Application")/_x0058_ML_Application/AppModID return { for $_x0058_ML_Application2 in collection("MSRB_Test_be.dbo.XML_Application")/_x0058_ML_Application/ApplicationNumber return { for $_x0058_ML_QuestionReply in collection("MSRB_Test_be.dbo.XML_QuestionReply")/_x0058_ML_QuestionReply return } { for $_x0058_ML_Risk in collection("MSRB_Test_be.dbo.XML_Risk")/_x0058_ML_Risk where ($_x0058_ML_Risk/LocID = collection("MSRB_Test_be.dbo.XML_Location")/_x0058_ML_Location/LocID) and (collection("MSRB_Test_be.dbo.XML_Location")/_x0058_ML_Location/LocNum = $_x0058_ML_Risk/LocNum) return { for $_x0058_ML_Coverage in collection("MSRB_Test_be.dbo.XML_Coverage")/_x0058_ML_Coverage return } { for $_x0058_ML_Building in collection("MSRB_Test_be.dbo.XML_Building")/_x0058_ML_Building where collection("MSRB_Test_be.dbo.XML_Line")/_x0058_ML_Line return } } { for $_x0058_ML_Location in collection("MSRB_Test_be.dbo.XML_Location")/_x0058_ML_Location return } { for $_x0058_ML_AI in collection("MSRB_Test_be.dbo.XML_AI")/_x0058_ML_AI where ($_x0058_ML_AI/InterestTypeCd != 'Primary Insured') return } { for $_x0058_ML_Insured in collection("MSRB_Test_be.dbo.XML_Insured")/_x0058_ML_Insured where ($_x0058_ML_Insured/InterestTypeCd = 'Primary Insured') return } { for $_x0058_ML_Fee in collection("MSRB_Test_be.dbo.XML_Fee")/_x0058_ML_Fee return } { for $_x0058_ML_TransInfo in collection("MSRB_Test_be.dbo.XML_TransInfo")/_x0058_ML_TransInfo return } { for $_x0058_ML_Location1 in collection("MSRB_Test_be.dbo.XML_Location")/_x0058_ML_Location return } } { for $_x0058_ML_Application2 in collection("MSRB_Test_be.dbo.XML_Application")/_x0058_ML_Application, $_x0058_ML_BillingApp in collection("MSRB_Test_be.dbo.XML_BillingApp")/_x0058_ML_BillingApp , $_x0058_ML_BillingTrans in collection("MSRB_Test_be.dbo.XML_BillingTrans")/_x0058_ML_BillingTrans where ($_x0058_ML_BillingTrans/TransactionDt != "") and (($_x0058_ML_Application2/AppModID = $_x0058_ML_BillingApp/AppModID) and $_x0058_ML_BillingApp/AppModID = $_x0058_ML_BillingTrans/AppModID) order by $_x0058_ML_BillingTrans/TransactionDt return } } (: Stylus Studio meta-information - (c) 2004-2009. Progress Software Corporation. All rights reserved. :)