【多选题】
A SELECT prod_id, exp_date FROM products UNION ALL SELECT prod_id,NULL FROM new_products;
B SELECT prod_id, prod_name FROM products INTERSECT SELECT 100,prod_name FROM new_products;
C SELECT * from products UNION SELECT*FROM new_products;
D SELECT * FROM products MINUS SELECT prod_id FROM new_products;
E SELECT prod_id FROM products UNION ALL SELECT prod_id,prod_name FROM new_products;
查看更多