Select same columns from multiple tables

using the union :

    select productid,price from table1
union select productid,price from table2
union select productid,price from table3