text: USE [Monopoly]
  GO
  
  /****** Object:  View [Game].[vwOffer_OfferorProperties]    Script Date: 2/19/2022 10:25:22 AM ******/
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  
  CREATE VIEW [Game].[vwOffer_OfferorProperties] AS
  SELECT a.[rowid] AS [offer], a.[offeror], c.[considered_property]
  FROM [Game].[Offers] a
  JOIN [Player].[PropertiesOwned] b ON a.[offeror] = b.[player]
  JOIN [Game].[OfferProperties] c
  	ON a.[rowid] = c.[offer]
  	AND b.[property] = c.[considered_property];
  GO
  
  
  