Query from right table

former_member204457 — Sat, 10 Mar 2012 17:10:18 GMT

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

Re: Query from right table

mejdi_brahem2 — Sat, 10 Mar 2012 19:27:04 GMT

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

topic Query from right table in Application Development and Automation Discussions

Query from right table

Re: Query from right table