使用union
select vend_id, prod_id, prod_price
from products
where prod_price <=5
union
select vend_id, prod_id, prod_price
from products
where vend_id in (1001, 1002);
包含重复的行
select vend_id, prod_id, prod_price
from products
where prod_price <=5
union all
select vend_id, prod_id, prod_price
from products
where vend_id in (1001, 1002);
对组合查询结果进行排序
select vend_id, prod_id, prod_price
from products
where prod_price <=5
union
select vend_id, prod_id, prod_price
from products
where vend_id in (1001, 1002);
order by vend_id, prod_price;