双表连接

您可创建双表连接、多表连接、自连接和外连接（ GBase 8s 扩展语法）。下列样例展示双表连接：

SELECT order_num, lname, fname FROM customer, orders
        WHERE customer.customer_num = orders.customer_num;