MariaDB [mytest]> select * from orders o, t1 where o.o_orderkey = c1 and o.o_orderkey <= 100;
|
+------------+-----------+---------------+--------------+-------------+-----------------+-----------------+----------------+--------------------------------------------------------------+------+
|
| o_orderkey | o_custkey | o_orderstatus | o_totalprice | o_orderdate | o_orderpriority | o_clerk | o_shippriority | o_comment | c1 |
|
+------------+-----------+---------------+--------------+-------------+-----------------+-----------------+----------------+--------------------------------------------------------------+------+
|
| 1 | 36901 | O | 173665.47 | 1996-01-02 | 5-LOW | Clerk#000000951 | 0 | nstructions sleep furiously among | 1 |
|
| 2 | 78002 | O | 46929.18 | 1996-12-01 | 1-URGENT | Clerk#000000880 | 0 | foxes. pending accounts at the pending, silent asymptot | 2 |
|
| 98 | 104480 | F | 69168.33 | 1994-09-25 | 1-URGENT | Clerk#000000448 | 0 | c asymptotes. quickly regular packages should have to nag re | 98 |
|
| 99 | 88910 | F | 112126.95 | 1994-03-13 | 4-NOT SPECIFIED | Clerk#000000973 | 0 | e carefully ironic packages. pending | 99 |
|
| 100 | 147004 | O | 187782.63 | 1998-02-28 | 4-NOT SPECIFIED | Clerk#000000577 | 0 | heodolites detect slyly alongside of the ent | 100 |
|
+------------+-----------+---------------+--------------+-------------+-----------------+-----------------+----------------+--------------------------------------------------------------+------+
|
5 rows in set (0.195 sec)
|