in oracle9i:
CREATE or replace VIEW dbo.vFlatDepositRecv
AS
SELECT LeaseContract.Tenant1 AS Tenant1,
LeaseContract.DateOfContract AS DateOfContract
FROM LeaseContract INNER JOIN
FlatDepositRecv ON
LeaseContract.RentCaseNum = FlatDepositRecv.RentCaseNum
---------------------------------------
in oracle8iSELECT LeaseContract.Tenant1 AS Tenant1,
LeaseContract.DateOfContract AS DateOfContract
FROM LeaseContract,FlatDepositRecv
where LeaseContract.RentCaseNum = FlatDepositRecv.RentCaseNum
CREATE or replace VIEW dbo.vFlatDepositRecv
AS
SELECT LeaseContract.Tenant1 AS Tenant1,
LeaseContract.DateOfContract AS DateOfContract
FROM LeaseContract INNER JOIN
FlatDepositRecv ON
LeaseContract.RentCaseNum = FlatDepositRecv.RentCaseNum
---------------------------------------
in oracle8iSELECT LeaseContract.Tenant1 AS Tenant1,
LeaseContract.DateOfContract AS DateOfContract
FROM LeaseContract,FlatDepositRecv
where LeaseContract.RentCaseNum = FlatDepositRecv.RentCaseNum
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货