The MySQL database which stores all your helpdesk data is organised into a series of tables. For example, the tickets table stores information about tickets.
The FROM clause specifies which database table your DPQL query is asking about. You can only pick one table.
All column references in the query must start with the table name specified in the FROM clause.
Note
If you want to retrieve information from multiple tables in a single query, see the section on Cross-referencing Table Fields for details.
For a list of valid tables, see the DPQL Field References section.
Please log in or register to submit a comment.