GBase 8s V8. 8 SQL Guide: Tutorial - 6.2.1 (2)

surface 1. Query results

  If you want to store the results of the self join in a temporary table , It will be INTO TEMP Clause appended to SELECT language
Sentence , And assign display labels to at least one group of columns , To rename these columns . otherwise , Repeating column names will result in errors , and
And will not create temporary tables .
The following query , It's similar to the picture 1, Mark from orders All columns selected by the table , And place these columns in a place called shipping Of
In the temporary table .
chart : Inquire about
SELECT x.order_num orders1, x.po_num purch1, 
 x.ship_date ship1, y.order_num orders2,  
 y.po_num purch2, y.ship_date ship2
 FROM orders x, orders y
 WHERE x.ship_weight >= 5 * y.ship_weight
 AND x.ship_date IS NOT NULL
 AND y.ship_date IS NOT NULL
 ORDER BY orders1, orders2
 INTO TEMP shipping;
If you from the table shipping Query in SELECT *, You can see the following lines .
chart : Query results
 orders1 purch1 ship1 orders2 purch2 ship2
 
 1004 8006 05/30/1998 1011 B77897 07/03/1998
 1004 8006 05/30/1998 1020 W2286 07/16/1998
 1004 8006 05/30/1998 1022 W9925 07/30/1998
 1005 2865 06/09/1998 1011 B77897 07/03/1998
 ⋮
 1019 Z55709 07/16/1998 1020 W2286 07/16/1998
 1019 Z55709 07/16/1998 1022 W9925 07/30/1998
 1023 KF2961 07/30/1998 1011 B77897 07/03/1998
You can connect a table to itself multiple times . The maximum number of self connections depends on the resources available to you .