1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
SELECT ext__0__0.RefTe1, ext__1.Pu_CodeSURF, ext.SolCrDt, ext__1.Pu_ID, ext.SolPu_ID_,
ext.SolCreID, ext__3__0.RefTe1, ext__3__1.EntID, ext__0.ActID, ext__3.PerID,
ext__3__1.EntCorpName, ext.SolID, ext__3.PerName, ext__0.ActName, ext__0.ActFstName,
ext__5.RefTe1, ext.SolPerId, ext__3.PerFstName, ext__3.PerEntId, ext__6.RefTe1
FROM Solicitation ext
LEFT OUTER JOIN Actor ext__0 on ext.SolCreID = ext__0.ActID
LEFT OUTER JOIN RefValues ext__0__0 on (ext__0.ActCivID = ext__0__0.RefID)
LEFT OUTER JOIN Purchase_ ext__1 on ext.SolPu_ID_ = ext__1.Pu_ID
LEFT OUTER JOIN Person ext__3 on ext.SolPerId = ext__3.PerID
LEFT OUTER JOIN RefValues ext__3__0 on (ext__3.PerCivID = ext__3__0.RefID)
LEFT OUTER JOIN Enterprise ext__3__1 on ext__3.PerEntId = ext__3__1.EntID
LEFT OUTER JOIN RefValues ext__5 on (ext.SolCanalID_ = ext__5.RefID)
LEFT OUTER JOIN RefValues ext__6 on (ext.SolMotiveID_ = ext__6.RefID)
LEFT OUTER JOIN Actor ext__8 on ext.SolActID = ext__8.ActID
LEFT OUTER JOIN RefValues ext__9 on (ext.SolPtyID = ext__9.RefID)
LEFT OUTER JOIN RefValues ext__10 on (ext.SolCatID = ext__10.RefID)
WHERE
( (UPPER(ext__3.PerName) LIKE UPPER(N'chaunu%') and UPPER(ext__3.PerFstName)
LIKE UPPER(N'enzo%')) or (UPPER(ext__3.PerName) LIKE UPPER(N'chaunu%')
and UPPER(ext__3.PerFstName) LIKE UPPER(N'% enzo%')) or
(UPPER(ext__3.PerName) LIKE UPPER(N'% chaunu%') and UPPER(ext__3.PerFstName)
LIKE UPPER(N'enzo%')) or (UPPER(ext__3.PerName) LIKE UPPER(N'% chaunu%')
and UPPER(ext__3.PerFstName) LIKE UPPER(N'% enzo%')))
ORDER BY ext.SolNextUpd ASC,ext__8.ActCode ASC,ext__9.RefTe1 ASC,ext__10.RefTe1 ASC |
Partager