TABLE Statement | 13 | 3 | | 9 | 5 | +----+----+ 3 rows in set (0.00 sec) • TABLE  always displays all columns of the table. • TABLE  does not allow for any arbitrary filtering of rows; that is,  TABLE  does not support any  WHERE clause. •With  UNION , as shown here: The  UNION  just shown is equivalent to the following statement: mysql>  SELECT * FROM t1 UNION SELECT * FROM t2; +---+----+ | a | b | +---+----+ | 2 | 10 | | 5 | 3 | | 7 | 8 | | 1 | 2 | | 3 | 4 | 2701 TABLE  differs from  SELECT  in two key respects: For limiting which table columns are returned, filtering rows beyond what can be accomplished using ORDER BY  and  LIMIT , or both, use  SELECT . TABLE  can be used with temporary tables. TABLE  can also be used in place of  SELECT  in a number of other constructs, including those listed here: mysql>  TABLE t1; +---+----+ | a | b | +---+----+ | 2 | 10 | | 5 | 3 | | 7 | 8 | +---+----+ 3 rows in set (0.00 sec) mysql>  TABLE t2; +---+---+ | a | b | +---+---+ | 1 | 2 | | 3 | 4 | | 6 | 7 | +---+---+ 3 rows in set (0.00 sec) mysql>  TABLE t1 UNION TABLE t2; +---+----+ | a | b | +---+----+ | 2 | 10 | | 5 | 3 | | 7 | 8 | | 1 | 2 | | 3 | 4 | | 6 | 7 | +---+----+ 6 rows in set (0.00 sec)