Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Infor record Query

antonio_bruno
Participant

‎2011 Oct 17 8:48 AM

0 Likes
556

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

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

Reply
2 REPLIES 2
Read only

Former Member

‎2011 Oct 17 9:21 AM

0 Likes
525

Hi Antonio,

What are the conditions of the join in your Query?

Filippo

Read only

antonio_bruno
Participant
In response to Former Member

‎2011 Oct 17 10:17 AM

0 Likes
525

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