web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) How to select multiple...

Microsoft Dynamics AX (Archived)

How to select multiple columns by joining tables

(0) Share

Report

Report

Posted on by Community Member

Hi all ,

I have created the below pasted Query to join three tables ..

I don't if it is correct . when I am executing , it is giving me a Syntax Error . Please Let me know if some thing is wrong there ?

select forupdate ( empltbl.EmplId,empltbl.DEL_Name,empE.FirstName
,empE.LastName,DAR.Email,empltbl.DEL_Phone,empltbl.Designation,empltbl.BirthDate ) from EmplTable empltbl JOIN EmplTable.emplId ON Employee.empId
where empltbl.EmplId == empE.EmpId && empltbl.EmplID > 1000 && empltbl.EmpId < = 2000 ;

regards ,

Nishath Salman N.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Florian Hopfner 2,461 on at

Like (1)

Report

While similar, the syntax of select statements in SQL and X++ are not the same. Take a look at Select Statement Syntax, your select statement does not follow that syntax.

Was this reply helpful? Yes No
Suggested answer

Nasheet Siddiqui 440 on at

Like (0)

Report

Check below links.

community.dynamics.com/.../how-joins-in-x-select-statement-are-translated-into-t-sql

daxdude.blogspot.com/.../select-statement-where-condition.html

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans