sql server查找一张表中和另外一张表中字段值相同的数据的语句怎么写

select b.*,a.* from a,b where a.paytype ='货到付款' and a.orderid=b.orderid