Inner Joins

Hello, are inner joins supported in SQL for AppDB?


var queryJoinTest = "SELECT REC.nombrer, RED.nombreo FROM Reconocimientos REC  "
queryJoinTest += "INNER JOIN Redeem RED ON REC.empr=RED.empo AND REC.empr ='" + EmpN + "';"

I've tried it in the same code line and sepparate, and it works both ways with a normal query. But it displays an error message when using the Inner Join clause



Also, does anyone have an update on the AppDB Updating Documents funtionality?


Thanks in advance


  • Did you try just 'JOIN'?

    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
This discussion has been closed.