You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

LSQL Newbie question

edited Oct 15, 2020 1:04AM in Reporting and Analytics for HCM 2 comments

Summary

Trying to learn to write LSQL. Need assistance with the error

Content

Hello all,

I just started learning to write LSQLs. After going thro the training materials, I ventured into writing a basic one but I keep encountering this error no matter what fields I chose. The individual pieces (data sets) of the LSQL works just fine but when when I put two queries together and join, I get this error. Can any one help with identifying what I am doing wrong? 

---------------------------------------------------------------------------------------------------
SELECT Person Number, Full Name, Location
FROM
(
SELECT A.EmpID Person Number, A.EName Full Name, B.Loc Location

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!