Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
LSQL Newbie question
Summary
Trying to learn to write LSQL. Need assistance with the errorContent
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
1