Add flag in sap query based on existence of status in another table

halo,

I have been trying using sap query to add column that has x flag if there is certain value in another table, for each record in affh-aufpl i need to know if there is jest-stat = 'e0003' (tables connet with objnr).

basiclly - show me all the rows for AFFH and tell me if there is active E0003 status in JEST.

I tried to use code to filter all the other status in sq02 and in sq01 whike set JEST as left join, didnt work.

Any ideas?

Thx.