List Records

On the "Edit SQL query" page, write your own SQL statement taking whatever fields you want from different tables.
Following example takes records from "orders" and "customers"
SELECT

orders.ID,

orders.OrderNumber,

orders.Customer,

customers.CustomerName,

customers.Address,

customers.City

FROM orders

INNER JOIN customers

ON orders.Customer = customers.ID