E9.2 Querying Multiple Tables in Query Manager

robertrio

Member
I am new to JDE and have searched for this topic, but have not found a definite answer.

Is it possible to query multiple tables using the Query Manager in JDE?

I would like to create a query that would drive a watchlist which would notify me if field values in the Address Book table differ from those in the Customer Master table. These would be Category Codes (UDC) fields.

Thank you very much.
 
Query manager only works over the tables in the BSVW defined on the form you are in. Or, if you are in databrowser, the table/view your are looking at. If the business view links multiple tables together then it queries over those tables. You cannot specify or link any tables outside of the view in query manager.
 
Back
Top