# 函數原型 ~~~ public function union($mixSelect = [], $sType = 'UNION'); ~~~ 說明：參數支持字符串、子查詢器以及它們構成的一維數組。 # 用法如下 ~~~ /* SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` UNION SELECT `yyyyy`.`yid` AS `id`,`yyyyy`.`name` AS `value` FROM `yyyyy` WHERE `yyyyy`.`first_name` = '222' UNION SELECT id,value FROM test2222 UNION SELECT `yyyyy`.`yid` AS `id`,`yyyyy`.`name` AS `value` FROM `yyyyy` WHERE `yyyyy`.`first_name` = '222' */ $objUnion1 = database::table ( 'yyyyy', 'yid as id,name as value' )->where ( 'first_name', '=', '222' ); $objUnion2 = 'SELECT id,value FROM test2222'; database::table ( 'test', 'tid as id,tname as value' ) ->union ( $objUnion1 ) ->union ( $objUnion2 ) ->union ( $objUnion1 ) ->getAll (); ~~~ # 也支持 unionAll 去掉前面兩個參數，后面的全部都是條件參數。 ~~~ /* SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` UNION ALL SELECT id,value FROM test2222 */ $objUnion1 = 'SELECT id,value FROM test2222'; database::table ( 'test', 'tid as id,tname as value' ) ->unionAll ( $objUnion1 ) ->getAll (); ~~~