want to check the row with previous column

select Rtrim(w1.Member_Name)+'&'+ w1.cname as name ,CAST(DAY(w1.wdate) AS VARCHAR(2)) + ' ' + DATENAME(MM, w1.wdate) AS wdate from Family_Member w1 inner join Family_Member w2 on  w1.M_No= w2.M_No and w2.marital =w1.marital and w2.marital ='Married' and w1.cname = w2.Member_Name and DATEADD(YEAR, DATEDIFF(YEAR,  w1.wdate, '9/27/2009'), w1.wdate) BETWEEN '9/27/2009' AND '9/30/2009' OR DATEADD(YEAR, DATEDIFF(YEAR,  w1.wdate, '9/30/2009'),w1.wdate) BETWEEN '9/27/2009' AND '9/30/2009' ORDER BY CASE WHEN DATEADD(YEAR, DATEDIFF(YEAR,  w1.wdate, '9/27/2009'), w1.wdate) BETWEEN '9/27/2009' AND '9/30/2009' THEN 1 ELSE 2 END, DATEPART(MONTH, w1.wdate), DATEPART(DAY, w1.wdate)

so pls correct my query

select 

w1.Name,w1.CoupleName,W1.WedddingDate

from wedding w1 inner join Wedding w2 on w1.No= w2.No

and w2.[alive status]= 'yes'  

and w2.coupleName <> '' and w1.WedddingDate <> ''