create proc test(@CustomerID int,@ProductID int)
as
select *
from Po表 A inner join PODetails表 B on B.POID = A.POID
where A.CustomerID=@CustomerID and B.ProductID=@ProductID
as
select *
from Po表 A inner join PODetails表 B on B.POID = A.POID
where A.CustomerID=@CustomerID and B.ProductID=@ProductID
@CustomerID int,
ProductID int
as
select * from poid a inner join PODetails b on a.POID=b.POID
where a.CustomerID=@CustomerID and b.ProductID=@ProductID
go
as
select *
from Po A inner join PODetails B on B.POID = A.POID
where A.CustomerID=@CustomerID and B.ProductID=@ProductID
@CustomerID int,
@ProductID int
as
select * from PO a,PODetails b where a.POID=b.POID
and a.CustomerID=@CustomerID and b.ProductID=@ProductID
go