First table table1
OrderId,
OrderName,
Date
Second table table2
OrderId,
Price,
Total
Select OrderId, price, total from table1 t1
inner join table2 t2 on t1.Orderid=t2.OrderId
Now this will give me only 3 columns. you can write whatever fields you want like this