SQLServer数据库表记录查询sql

--查询一对多关系数据库表字段

select
  a.ordermc as 订单名称,
  convert(varchar,a.orderdate,120)as 订单日期,
  b.ordermxname as 明细名称,
  isnull(b.price,0)as 单价,
  isnull(b.number,0)as 数量,
  (isnull(b.price,0)*isnull(b.number,0))as 总金额
from [order] a,ordermx b
where a.orderid=b.orderid