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

Comments

  • Did you try just 'JOIN'?

    DataMaven
    Breaking Down Silos - Building Bridges
    Check out my video!
    **Say "Thanks" by clicking the heart 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.