SELECT TD.*, ; mLookup.cValue AS cLevel1, ; mLookup_A.cValue AS cLevel2, ; mLookup_B.cValue AS cLevel3, ; (SELECT TOP 1 iPartyID ; FROM VSO3!sDocsParty SDP ; WHERE iPID = TD.iID ; ORDER BY iPID) AS iPartyID ; FROM VSO3!tDocs TD ; LEFT JOIN VSO3!mLookup ; ON TD.ILvl1ID = mLookup.iID ; LEFT JOIN VSO3!mLookup mLookup_A ; ON TD.ILvl2ID = mLookup_A.iID ; LEFT JOIN VSO3!mLookup mLookup_B ; ON TD.ILvl3ID = mLookup_B.iID ; ORDER BY mLookup.cValue, mLookup_A.cValue, mLookup_B.cValue>>
>>SELECT TD.*, ; >> mLookup.cValue AS cLevel1, ; >> mLookup_A.cValue AS cLevel2, ; >> mLookup_B.cValue AS cLevel3, ; >> (SELECT TOP 1 iPartyID ; >> FROM VSO3!sDocsParty SDP ; >> WHERE iPID = TD.iID ; >> ORDER BY iID) AS iPartyID ; >> FROM VSO3!tDocs TD ; >> LEFT JOIN VSO3!mLookup ; >> ON TD.ILvl1ID = mLookup.iID ; >> LEFT JOIN VSO3!mLookup mLookup_A ; >> ON TD.ILvl2ID = mLookup_A.iID ; >> LEFT JOIN VSO3!mLookup mLookup_B ; >> ON TD.ILvl3ID = mLookup_B.iID ; >> ORDER BY mLookup.cValue, mLookup_A.cValue, mLookup_B.cValue >> >>