Using the Management Portal's query tool, you can execute SQL queries directly against your database tables. Here are the steps:
On the SQL page, click the
Enter an SQL query in the SQL Query
text box. Click Execute Query
. The query results are displayed at the bottom of the page.
This query returns the contacts who have fax numbers. Notice the use of the ->
in the query. This is the Caché implicit join
operator or arrow syntax
. It provides an easy shorthand for retrieving data from related tables without explicitly specifying a JOIN.