TripperDay
MIS
I've got two views I want to link together, but the field I want to link on in one table has some extra characters, so I want to add a command like LEFT or SUBSTRING, but get an error like "Expected lexical element not found: <identifier>" or "Expected lexical element not found: FROM"
I want my SELECT statement to look like this:
SELECT LEFT("View1"."Request ID",11) AS "ReqID", "View2"."Request Number"
Then link View1 to ReqID in Command, and View2 to Request Number in Command.
I want my SELECT statement to look like this:
SELECT LEFT("View1"."Request ID",11) AS "ReqID", "View2"."Request Number"
Then link View1 to ReqID in Command, and View2 to Request Number in Command.