web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Join two tables in Que...
Microsoft Dynamics AX (Archived)

Join two tables in Query and View results by creating View

(0) ShareShare
ReportReport
Posted on by Safeer PS 507

Hi all,

I have create a simple query on dept and employee tables on emp.dept_id == dept.dept_id.

Now I have created a view and dragged the simple query to Meta data of view. I have added fields of view from

emp and dept table.

Now if try to open the view it is showing error.

Error:

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'EMP_NAME'.

It is showing results when fields only  from dept or emp  table  . But when I mix dept and emp table fields following error shown.

4353.ax-error.PNG

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,880 Most Valuable Professional on at

    First of all, make sure that the database in synchronized with your changes in the application.

  • Safeer PS Profile Picture
    Safeer PS 507 on at

    I didnt get you..

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 237,880 Most Valuable Professional on at

    That will be the problem then...

    Right-click the view and choose Synchronize. That will add your new view to database - you can try to use it before that.

  • Safeer PS Profile Picture
    Safeer PS 507 on at

    Now colmns from emp table showing columns from dept shows as "unretrieved"

    ax-error-2.PNG

  • Safeer PS Profile Picture
    Safeer PS 507 on at

    OKAY i got iT..

    Thank u ver much

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans