But unfortunately it shows all
I need only show: WHERE estmarh.SchID = users.SchID
// Recordset Selecting event
function Recordset_Selecting(&$filter) {
// Enter your code here
if (CurrentUserLevel() ==3 && CurrentUserLevel() <> -1) {
ew_AddFilter($filter, "SELECT DISTINCT estmarh.SchID AS SchID,
users.SchID AS SchID1,
estmarh.*
FROM estmarh
JOIN users ON estmarh.SchID = users.SchID
WHERE estmarh.SchID = users.SchID
");
}}
Please help write the right code