SELECT
CONCAT(WebAddresses.Address WITH PagesTimeline.Parameters),
PagesTimeline.Date, 
PagesTimeline.Time, 
WebAddresses.Address,
PagesTimeline.Parameters,
PagesTimeline.Length, 
PagesTimeline.Title,
p.AddressID
FROM PagesTimeline p
INNER JOIN WebAddresses ON WebAddresses.ID = PagesTimeline.AddressID 
WHERE ( CONCAT(WebAddresses.Address WITH
               PagesTimeline.Parameters) LIKE '%onet.pl/se%' )
ORDER BY PagesTimeline.Date, PagesTimeline.Time ASC

---

 Comments

---

The issue was with the CONCAT() function - ElevateDB was not properly handling such a situation and was trying to apply the condition to the WebAddresses table instead of evaluating the condition against the rows produced from the joins.

---

 Resolution

---

Fixed Problem on 3/5/2010 in version 2.03 build 9

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial