The Original FileMaker Forum
The FMT FileMaker Network

ExecuteSQL confusion

Tagged: ,

  • Posted In: Calculations and Define Fields


  • Member
    #30211

    I was reading this document here and I am stuck on what the E, S, are referring to in the line

    100 * Salary::Salary / ExecuteSQL(“select sum(S.salary) from Employees E join Salary S on E.EmpID = S.EmpID where E.Department = ?”; “”; “”; Department)
    [/CODE]

    If S and E are abbreviations for the Employees and Salaries table when was that defined? Or does it just go without saying? Why is the E after Employees at one part of the statement?[CODE]
    100 * Salary::Salary / ExecuteSQL(“select sum(S.salary) from Employees E join Salary S on E.EmpID = S.EmpID where E.Department = ?”; “”; “”; Department)
    [/CODE]

    If S and E are abbreviations for the Employees and Salaries table when was that defined? Or does it just go without saying? Why is the E after Employees at one part of the statement?

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.