Gå till huvudinnehåll

FROM

i Anatomy of a DPQL query
Författarlista
Publicerad: 16 mars 2017|Senast Uppdaterad: 3 nov. 2022

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.

HjälpfullOanvändbar
nästa sidaWHERE
föregående sidaSELECT

Logga in eller registrera dig för att lämna en kommentar.