Query from right table

[former_member204457]

hi gurus,

I've requirement for report to retrieve all equipment in PM module. For that I'm using table equi, equz and iloa. I need to match this to table anla in AA. As such I get all the equipment from PM tables plus matching details from anla table for equipment that are attached to an asset (matching iloa-anlnr to anla-anln1, etc.).

My dilemma is, I also need to get all the assets that don't have a matching record in iloa. So I need to get all equipment and for those that have assets, match them to anla plus all other assets in anla for which there is no matching record in iloa.

any idea how I can achieve this?

thank you

[mejdi_brahem2]

Hi,

I think that you have to create a report. If I understand well, you need to get data that do not exist in ILOA. If so, you canu2019t apply this logic in a query.

Best Regards