Inner Joins

MartinB

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

DataMaven

Did you try just 'JOIN'?