SELECT foo,bar 
FROM
  (SELECT integer(id) AS foo,string(title) AS bar 
   FROM publicdata:samples.wikipedia limit 10),(SELECT integer(year) AS foo,string(state) AS bar 
   FROM publicdata:samples.natality limit 10);

这几乎完全相当于sql@H_301_4@

SELECT id AS foo,title AS bar 
FROM publicdata:samples.wikipedia limit 10
UNION ALL
SELECT year AS foo,state AS bar 
FROM publicdata:samples.natality limit 10;

(注意,如果想要sql UNION而不是UNION ALL,这将不起作用)@H_301_4@

或者,您可以运行两个查询并追加结果.@H_301_4@