You can call an SQL stored procedure with the execute, open, or get statement; in each case, you use the #sql directive. A stored procedure is a set of instructions for a database, like a function in EGL.

Records from a (INNER) JOIN are those with matching values in both tables.

RIGHT (OUTER) JOIN: Returns the matched records from the right table along with all of the records from the left table.
RIGHT (OUTER) JOIN: Returns all data from the right table together with the data from the left table that matches.

Different Types of SQL JOINs (INNER) JOIN: Returns records from both tables that have matching values.
LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
RIGHT (OUTER) JOIN : Returns all records from the right table, and the matched records from the left table.