--Create Product Table and enter in sample values CREATE TABLE ##ProductChild (ID INT, ChildDescription VARCHAR(100), FKID INT) INSERT INTO ##ProductChild (ID, ChildDescription, FKID) VALUES (1, 'SQL Server', 10) INSERT INTO ##ProductChild (ID, ChildDescription, FKID) VALUES (2, 'MySQL', 20) INSERT INTO ##ProductChild (ID, ChildDescription, FKID) VALUES (3, 'Oracle', 30) INSERT INTO ##ProductChild (ID, ChildDescription, FKID) VALUES (4, 'SQL Server 2000', 10) INSERT INTO ##ProductChild (ID, ChildDescription, FKID) VALUES (4, 'SQL Server 2005', 10) INSERT INTO ##ProductChild (ID, ChildDescription, FKID) VALUES (4, 'SQL Server 2008', 10) INSERT INTO ##ProductChild (ID, ChildDescription, FKID) VALUES (5, 'Enterprise Edition SQL Server 2008', 10) --Create Parent SQL Server Yes/No table and enter in sample values CREATE TABLE ##ProductParent (ID INT, Item VARCHAR(100)) INSERT INTO ##ProductParent (ID, Item) VALUES (10, 'SQL Server') INSERT INTO ##ProductParent (ID, Item) VALUES (20, 'Non-SQL Server')