Hi Folks,

Should the following two sql statements produce the same result
(they don't)

select
a.ordering,
u.*
from unit u
left join my_mimic_asset a
on a.plant=u.u_plant and a.area=u.u_area and a.unit=u.u_unit and
a.mimic_id = '0NUmDq*4Ibdl4m5R5VdG*W'
where u.u_plant = 'CV1ES' and u.u_area = 'EFPP'
order by u.u_plant, u.u_area, u.u_unit

and

select
a.ordering,
u.*
from unit u
left join my_mimic_asset a
on a.plant=u.u_plant and a.area=u.u_area and a.unit=u.u_unit
where u.u_plant = 'CV1ES' and u.u_area = 'EFPP' and a.mimic_id
= '0NUmDq*4Ibdl4m5R5VdG*W'
order by u.u_plant, u.u_area, u.u_unit

The only difference is the location of the and a.mimic_id = '..'
The first one works as expected, the second returns no rows.

Server is firebird 1.0.2.

Regards
Ian A. Newby