Editor - Join single record from one-to-many table with search functionality

reasy_@hotmail.com

Hi,

I have a table that has a one to many relationship with a secondary table.
I only want to join the latest entry from the secondary table which i have managed to do with a standard join.

However, i can not search the field from the joined table. It displays errors.

I dont want to use a standard leftJoin as it brings back a row for each entry within the secondary table, i only want the latest entry. Is this possible keeping the searching functionality?

Thanks