topic Infor record Query in Application Development and Automation Discussions

Infor record Query

antonio_bruno — Mon, 17 Oct 2011 07:48:16 GMT

Hi,

i've created a query to show the Info records not open for a specific division.

I've joined the tables EINA and EINE and selected only the records with WERKS equal to "". But some of these info records have a records with divisions.

Is there is an alternative way to show the info records not created for a specific division?

Thanks

Antonio

Re: Infor record Query

Former Member — Mon, 17 Oct 2011 08:21:35 GMT

Hi Antonio,

What are the conditions of the join in your Query?

Filippo

Re: Infor record Query

antonio_bruno — Mon, 17 Oct 2011 09:17:17 GMT

Hi Filippo,

i've joined EINA and EINE with INFNR.

When i execute the query, in the selected fields, i insert equal to "" for the Division (EINE-WERKS).

Thanks.

Antonio