第一个view1
SELECT dbo.BoxLabelTable.BoxLabelID, dbo.BoxLabelTable.BoxSN,
dbo.ElabelTable.ESN
FROM dbo.BoxLabelTable INNER JOIN
dbo.ElabelTable ON dbo.BoxLabelTable.BoxLabelID = dbo.ElabelTable.BoxLabelID
第二个view1
SELECT dbo.VIEW1.BoxSN, dbo.VIEW1.ESN, dbo.JLabelTable.JLabelSN,
dbo.JLabelTable.ProductName
FROM dbo.VIEW1 INNER JOIN
dbo.JLabelTable ON dbo.VIEW1.BoxLabelID = dbo.JLabelTable.BoxLableID
怎样才能把上面两个sql语句一次性变成一起呢?谢谢!
SELECT dbo.BoxLabelTable.BoxLabelID, dbo.BoxLabelTable.BoxSN,
dbo.ElabelTable.ESN
FROM dbo.BoxLabelTable INNER JOIN
dbo.ElabelTable ON dbo.BoxLabelTable.BoxLabelID = dbo.ElabelTable.BoxLabelID
第二个view1
SELECT dbo.VIEW1.BoxSN, dbo.VIEW1.ESN, dbo.JLabelTable.JLabelSN,
dbo.JLabelTable.ProductName
FROM dbo.VIEW1 INNER JOIN
dbo.JLabelTable ON dbo.VIEW1.BoxLabelID = dbo.JLabelTable.BoxLableID
怎样才能把上面两个sql语句一次性变成一起呢?谢谢!
FROM dbo.BoxLabelTable INNER JOIN
dbo.ElabelTable ON dbo.BoxLabelTable.BoxLabelID = dbo.ElabelTable.BoxLabelID
Inner Join dbo.JLabelTable ON dbo.BoxLabelTable.BoxLabelID = dbo.JLabelTable.BoxLableID