SQL_视图_将两个表结合在一起

以dbo.Exp_RawEdge.MATNR字段为对象，

将表dbo.Exp_RecordBable与表dbo.Exp_RawEdge的相关字段结合在一起。

SELECT dbo.Exp_RecordBable.MATNR, dbo.Exp_RecordBable.PO_QTY, dbo.Exp_RecordBable.TOTAL_QTY,
dbo.Exp_RecordBable.SURPLUS_QTY, dbo.Exp_RawEdge.THPRTIME
FROM dbo.Exp_RecordBable INNER JOIN
dbo.Exp_RawEdge ON dbo.Exp_RecordBable.MATNR = dbo.Exp_RawEdge.MATNR