create table test (id uniqueidentifier,[option] nvarchar(5))
select [test].[option] from test
 
 
create table test1 (id uniqueidentifier, status nvarchar(10))
select [test].[option], test.id from test inner join test1 on(test.[option] = _
  test1.status)