AvailablePRB0000A Office 4 172.20.20.0PRB0000B Windows 5 172.40.40.0
PackagesPRB0000A WindowsPRB0000B OfficePRB0000C Tools
Subnets172.20.20.0172.40.40.0172.50.50.0
Desired Table resultPRB0000A Office 4 172.20.20.0PRB0000A Office 0 172.40.40.0PRB0000A Office 0 172.50.50.0PRB0000B Windows 0 172.20.20.0PRB0000B Windows 5 172.40.40.0PRB0000B Windows 0 172.50.50.0PRB0000C Tools 0 172.20.20.0PRB0000C Tools 0 172.40.40.0PRB0000C Tools 0 172.50.50.0
Here is a quick T-SQL to create these 3 tables.DECLARE @Available TABLE (Package VARCHAR(20), Name VARCHAR(20), Avail INT, Subnet VARCHAR(20))INSERT INTO @AvailableSELECT'PRB0000A','Office',4,'172.20.20.0'UNION ALLSELECT'PRB0000B','Windows',5,'172.40.40.0'DECLARE @Packages TABLE (Package VARCHAR(20), Name VARCHAR(20))INSERT INTO @PackagesSELECT'PRB0000A','Windows'UNION ALLSELECT'PRB0000B','Office'UNION ALLSELECT'PRB0000C','Tools' DECLARE @Subnets TABLE (Subnet VARCHAR(20))INSERT INTO @SubnetsSELECT'172.20.20.0'UNION ALLSELECT'172.40.40.0'UNION ALLSELECT'172.50.50.0'